Displaying Change in a Pivot Table

[#1]

PFA the qlikview file.

here I want a column called "Change" as follows.  Change is basically calculated as Mar2013 -minus June 2013, Sep2013 minus June2013 and so on. Any help would be great.

Mar2013   Change   June2013  Change   Sep2013   Change Feb2014

600           900          1500          500         2000          -1000      1000

Thanks,

Ram

[#2]

tresesco, this is how it is now, a straight table with individual expressions. Once they load a data for more periods in the future, we have to go and modify the chart. which i think is not advisable. That is why i am looking for a viable solution. I basically want to pivot the period so that they appear in the column and be more dynamic. only think i am unable to achieve is the difference.

[tresesco · Accepted solution]

See attached a better option.

[mangalsk]

Hello ,

For expression level use following:

=fabs(sum(Count)- Above(sum((Count))))

[#5]

No Mangal. Doesn't work in a Pivot table.

[Anonymous]

Hi,

Please find the attached file. Is it this what you what?

Thanks and Regards,

Jerry