RangeSum in Pivot Table Multiple Dimensions Returns Incorrect Results When Expanded
Hi. I have a pivot table with two dimensions, and I'm using RangeSum with Above to generate a cumulative total. The following expression works when the pivot table is collapsed; however, when I expand it, the cumulative total returns zero. Any ideas how to fix? I saw a similar post except it had multiple columns across here -->
MonthYear and Vendor (when I expand into multiple Vendors under a given MonthYear, that is what the incorrect result occurs) - the MonthYear cumulative total changes to zero, and the subtotals by vendor are cumulative within a given MonthYear but not cumulative by vendor (the latter is what I need). If that makes any sense.
Just to illustrate the issue a bit further, below is the expected result when expanding on MonthYear in the pivot table (fake data below). I cannot get the cumulative totals under Vendor to appear correctly. The cumulative totals in bold below appear correctly by MonthYear, just not by Vendor. Any ideas?
I think I got it to work, but I ran into a different issue to make this work. Suppose I have the following set analysis where I only want the set qualifiers to apply to the first Placed element - any way to achieve? I tried breaking this up into two sum()'s, but then embedding that within an "Above" and RangeSum didn't seem to work in Qlik.