Hello Excel Gurus,
I am trying to make a movement analysis workbook.
I can make the pivot from column A-I. But I'm having trouble executing the spreadsheet like K-Q.
I used PowerQuery to manipulate the data, then used a normal pivot table to get it in the desired format.
However, (column K onwards), I cant seem to get the Calculated Field portion working because it seems like the same columns need to be side-by-side in order to calculate "Difference from/Difference from %"
Sorry I couldnt seem to work out how to publish the sample workbook on the forum.
Thanks so much for your help.
I am trying to make a movement analysis workbook.
I can make the pivot from column A-I. But I'm having trouble executing the spreadsheet like K-Q.
I used PowerQuery to manipulate the data, then used a normal pivot table to get it in the desired format.
However, (column K onwards), I cant seem to get the Calculated Field portion working because it seems like the same columns need to be side-by-side in order to calculate "Difference from/Difference from %"
Sorry I couldnt seem to work out how to publish the sample workbook on the forum.
Thanks so much for your help.