Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I'm doing cumulative sum - that is working fine, but if user select any product cumulative value should not be change.
below is my cumulative sum and I'm selecting one product as Tab, here cumulative sum has changed to 10.
Cumulative Sum: RangeSum(Above(TOTAL Sum(Sales), 0, RowNo(TOTAL)))
I did some work around when user select product, finding MIN and MAX value
like Min(Sales) and max({<Product=>}Sales)) - same way applied in set expression
=Sum({<Sales ={">=$(=min(Sales)) <=$(=max({<Product=>}Sales))"}, Product=>}total Sales) - this expression is working fine for one product selection.
but my problem is when user select multiple products not working.
my output should be:
if user select single product or Multiple products should not be change the cumulative value (If any sub filter selections cumulative should not change)
Thanks in Advance!
Try:
If(Sum({<Product,[Category ],[Sub Category ]>}Sales)=Above(Total Sum({<Product,[Category ],[Sub Category ]>}Sales1)),
rangesum(above(total sum( {<Product,[Category ],[Sub Category ]>} Sales),1,RowNo(TOTAL))),
rangesum(above(total sum( {<Product,[Category ],[Sub Category ]>} Sales),0,RowNo(TOTAL)) ))