Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello~!
I would like to calculate the MTD figure using the rangesum and before function in the pivot table, it's OK if there is only one dimension in the pivot table, but the result isn't my expectation when there are two dimension, please refer as below and the attached file. Thanks a lot.
Hi
You need a TOTAL in the Before(). See updated qvw attached.
HTH
Jonathan
What is the expected?
Dear WU,
It wont't work on PIVOT TABLE,
It is restricted for Straight table.
Regards
Kiran Rode
91 8976977897
If you delete the day from the dimension you get the right values.
Note the following limitation:
If the pivot table has multiple horizontal dimensions, the current row segment will include only columns with the same values as the current column (which is your month) in all dimension rows except for the row showing the last horizontal dimension of the inter field sort order (which would be your Week). The inter field sort order for horizontal dimensions in pivot tables is defined simply by the order of the dimensions from top to bottom.
Hi
You need a TOTAL in the Before(). See updated qvw attached.
HTH
Jonathan
Hi Jonathan,
Can you pleasetell me how expression
=RangeSum(Alt(Before([Count YTD]), 0), sum(Count)) will work.
Thanks