How to calculate difference between only the last 2 columns at the end of pivot table?

Thu, 25 May 2017 11:41:33 GMT

Hello,

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

Re: How to calculate difference between only the last 2 columns at the end of pivot table?

kamal_sanguri — Thu, 25 May 2017 13:31:51 GMT

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

topic How to calculate difference between only the last 2 columns at the end of pivot table? in QlikView

How to calculate difference between only the last 2 columns at the end of pivot table?

Re: How to calculate difference between only the last 2 columns at the end of pivot table?