query to calculate diff between 2 month data

[amita1621]

I have attached a file for the  reference i have  created the file with current and prev month data by using pivot in qlikview, now how can i calculate % change from Prior Month.

COuld you please help??

[amita1621]

Please see the attached QV file. i am getting % for each band , how can i have the total change at the end, same as above excel attcahed

[sunny_talwar]

Amita, would you be able to share a more representative sample to help you better

[amita1621]

yes sure thanks

[amita1621]

Sorry  to bother so many times.

Please check the qlikview file i created and now i need % change at the last based on Month