Forum Discussion

Stryfe24's avatar
Stryfe24
Copper Contributor
Jun 19, 2023

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 the previous week, and for this to update as time goes on and more data drops in.  How would i go about achieving this?

 

Thanks

BI & Data Analysis
excel
Formulas and Functions

1 Reply

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Jun 25, 2023

    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

     

     

Resources