Use the RangeSum and Before function in the Pivot Table

[#1]

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.

[Clever_Anjos]

What is the expected?

[kiranmanoharrode]

Dear WU,

It wont't work on PIVOT TABLE,

It is restricted for Straight table.

Regards

Kiran Rode

91 8976977897

[danieloberbilli]

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.

[jonathandienst · Accepted solution]

Hi

You need a TOTAL in the Before(). See updated qvw attached.

HTH

Jonathan

[deepakqlikview_123]

Hi Jonathan,

Can you pleasetell me how expression

=RangeSum(Alt(Before([Count YTD]), 0), sum(Count)) will work.

Thanks