In this case use table calculation fro running difference
Hope this helps,
Otherwise attach a sample workbook here and I will try to find solution for this.
2 of 2 people found this helpful
1) Drag the quick table calculation to Measures. This will create a calculated field and let you name it, fo it % of Total.
2) Create a new calculated field that is [% of Total] - LOOKUP([% of Total],-1), call this Diff of % of Total.
3) Drag Diff of % of Total to Text.
4) Right click on the pill you just added, choose Edit Table Calculation and set the compute using for the nested calculation to be on Month or Table (Across).
I set up an example view using Superstore sample data:
for your valuable feedback.
Thank you Jonathan so so much! It worked!