Hello everyone,
Below is a simplification of a pivvottable (OLAP!) I've created. I'm having trouble adding a column that shows the difference between the two periods
Can anyone point me in the right direction?
Thank you.
Below is a simplification of a pivvottable (OLAP!) I've created. I'm having trouble adding a column that shows the difference between the two periods
- I cannot use a calculated column because the source is OLAP/cube
- I cannot figure out how to use an MDX measure because there is only 1 value field (I can make this work for YTD & LYTD (year to date) because they have their own fields in the cube. MDX measure in that document is simply "[YTD] - [LYTD]").
- It needs to auto populate. It cannot become a manual task with regular formulas.
- Only 2017 and 2018 are showing because of a slicer.
Can anyone point me in the right direction?
Thank you.
Last edited: