I´m having a problem with a Rangesum expression and need your help.
I´ve got a pivot table with two Dimensions, Month and Day. Then I´ve got in the expressions my Sales , Sales LAst year, and then my problem appears... I need to have a YTD, that gives me accumulated values for Month and Day when I expand my Day dimension is expanded. That´s when I cannot see what I wish. My Values for YTD Month are fine, and for Accumulated Day granularity are also fine, but with January expanded (or another Month), the other Months do not accumulate, giving me just the Sales for each Month by it self.
I´m using this expression:
=RangeSum(Alt(Above(TOTAL [myexpressionName]), 0), rangesum(above(sum({$<Year={2013}>} (A - B - C)),0)))
My Sales expression is a Calculated sum of A - B - C
Reminding that My Values are fine when Day is not expanded;
My Accumulated Days Values are also fine;
Only my Months that are NOT expanded, that doesn´t Accumulate, giving me just each Month Total.
I´ve tried to Start the expression with Sum(Aggr(...)), but that mess with my values and does not give me what I need.
In fact, your example works just fine (That´s why I marked it as Correct Answer), however when deploy it to my data, the first two rows are messed up... First Row (Jan) shows Jan and Feb sum, the second row (Feb) shows just Feb, after that it´s all fine. This continues even when Day Dimension is expanded. All days are fine, but sub-totals(with January expanded) show Jan + Feb, then Feb (witch is collapsed) stays showing just Feb, after that all values are fine!
Here is the Excel File, with non aggregated Dummy Data as it comes from client (I cannot send original Data, so I put "1" in every field). I don´t think that there is any problem with the data. It´s just a Date, and 3 fields, where the calculations will be A-B-C in this case.
I´ve tried to aggregate it in Script, doing "Sum(A-B-C) as Sales (...) group by Date", and also tried in formula, (A-B-C), substituting "Sales". Always shows it as I said it above. Wrong values in Jan, and Feb...
