Use the RangeSum and Before function in the Pivot Table
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.
Re: Use the RangeSum and Before function in the Pivot Table
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.