Rangesum by row in a pivot table

[Walakorn]

Hi Experts, 

I have a pivot table and want to use the rangesum function, but it only works for 1 dimension when I add more than 1. It doesn't work at all, as the picture below shows.

Please help me to fix this problem.

Sum-Target =   SUM(AGGR( IF( Target - Inventory >0 , Target - Inventory, 0 ) ,MKTName,Memeory,Color,ID) )

Rangesum = RANGESUM( ABOVE ( SUM( AGGR( IF( Target - Inventory >0 , Target - Inventory, 0 ) ,MKTName, Memory,Color,SiteID) ) ,0, RowNo() ) )

Many thanks in advance

Best regards,

Walakorn  T.

[Chanty4u]

Try this 

Sum-Target = SUM(AGGR(IF(Target - Inventory > 0, Target - Inventory, 0), MKTName, Memory, Color, ID))

Rangesum = 

    IF(ROWNO() = 1, Sum-Target,

        Rangesum(Above(Sum-Target, 0, ROWNO()-1)) + Sum-Target)

[Walakorn]

@Chanty4u 

Thank you for responding, but it still doesn't cumulative sum for two dimensions.