Aggr(RangeSum(Above( function not working

[shreya_nadkarni]

Hello Everyone.

Need help in writing the expression for Bar chart.

The req is  for date 07/09/2018 for the BU need to Minus the Above value and so on.

Expected Output  -07/09/2018 for BU(IBG1) ----value should be 21-12.

                             -07/09/2018 for BU(IBG2)----value should be 3-2

Thanks for the helps.

loveisfail‌stalwar1‌@

[shreya_nadkarni]

Thanks a lot stalwar1‌ loveisfail‌.

This was indeed helpful.

[shreya_nadkarni]

Hi Sunny,

Only after using a mapping table  SortTable where i sorted in asc in script did it work.

Also i had to use the new field SNAPSHOT_DATE_SORT instead of the original SNAPSHOT_DATE in my expression then the chart gave me the proper result.

Thanks a lot.