Forum Discussion
Week on Week % in a pivot table
Hi all, I have a pivot table which provides a sales volume per week commencing. I want to be able to add in a row into the pivot table which calculates the weekly % uplift or decreased based on ...
Hi Stryfe24
I want to be able to add in a row into the pivot table which calculates the weekly % uplift or decreased based on the previous week
Usually PivotTable measures go to columns but putting them on rows is doable (are there limitations? I have no idea) with Excel, basic example (attached):
https://exceleratorbi.com.au/measures-on-rows-here-is-how-i-did-it/ By Matt Allington