@Wayne Van Sluys its a calculated field . Below is the logic AGGREGATE( SUM( CASE WHEN YYYYMM = AGGREGATE(MAX(YYYYMM) BY ENTITY THEN CUR ELSE 0 END ) BY Category ) - AGGREGATE( SUM( CASE WHEN YYYYMM = AGGREGATE(MAX(YYYYMM) BY BY ENTITY - 100 THEN CUR ELSE 0 END ) BY Category )

Hi All , any solution for this?

Hi @Rajakumar Burra , It doesn work. Are we hardcoding the month here? I want it to be dynamic. Example at any time it should take the 2 months in the available dataset.