Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
How to calculate difference between only the last 2 columns at the end of pivot table?
Org | Ageing_range | Period_MonthName | Dec 2016 | Jan 2017 | Feb 2017 | Mar 2017 | Apr 2017 | May 2017 | Difference Between Apr and May 2017 here |
SHP | 1. less than 3 months | 5,337,160.88 | 5,337,160.88 | 5,337,160.88 | 5,337,160.88 | 5,337,160.88 | 5,337,160.88 | ? | |
SHP | 2. between 3 and 6 months | 2,317,251.17 | 2,317,251.17 | 2,317,251.17 | 2,317,251.17 | 2,317,251.17 | 2,317,251.17 | ||
SHP | 3. between 6 and 9 months | 527,034.63 | 527,034.63 | 527,034.63 | 527,034.63 | 527,034.63 | 527,034.63 | ||
SHP | 4. between 9 and 12 months | 254,430.23 | 254,430.23 | 254,430.23 | 254,430.23 | 254,430.23 | 254,430.23 | ||
SHP | 5. between 12 and 24 months | 249,442.02 | 249,442.02 | 249,442.02 | 249,442.02 | 249,442.02 | 249,442.02 | ||
SHP | 6. greater than 24 months | 47,604.90 | 47,604.90 | 47,604.90 | 47,604.90 | 47,604.90 | 47,604.90 | ||
SHP | Total | 8,732,923.84 | 8,732,923.84 | 8,732,923.84 | 8,732,923.84 | 8,732,923.84 | 8,732,923.84 | ||
WHS | 1. less than 3 months | 14,946,034.39 | 14,946,034.39 | 14,946,034.39 | 14,946,034.39 | 14,946,034.39 | 14,946,034.39 | ||
WHS | 2. between 3 and 6 months | 1,379,144.18 | 1,379,144.18 | 1,379,144.18 | 1,379,144.18 | 1,379,144.18 | 1,379,144.18 | ||
WHS | 3. between 6 and 9 months | 208,215.23 | 208,215.23 | 208,215.23 | 208,215.23 | 208,215.23 | 208,215.23 | ||
WHS | 4. between 9 and 12 months | 91,040.03 | 91,040.03 | 91,040.03 | 91,040.03 | 91,040.03 | 91,040.03 | ||
WHS | 5. between 12 and 24 months | 36,569.00 | 36,569.00 | 36,569.00 | 36,569.00 | 36,569.00 | 36,569.00 | ||
WHS | 6. greater than 24 months | 15,668.31 | 15,668.31 | 15,668.31 | 15,668.31 | 15,668.31 | 15,668.31 | ||
WHS | Total | 16,676,671.14 | 16,676,671.14 | 16,676,671.14 | 16,676,671.14 | 16,676,671.14 | 16,676,671.14 | ||
Total | 25,409,594.98 | 25,409,594.98 | 25,409,594.98 | 25,409,594.98 | 25,409,594.98 | 25,409,594.98 |
Hi,
Till the time you have dimension (Period_MonthName) dragged over horizontally. It would not be possible to show the difference in one column. Any new expression would get splitted under different Period.
something like this..
I think you have to revisit your data model to get it done.
Regards,
-Kamal