Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)