Percentage of specific amounts in Pivot Table

[#1]

I am doing financials in qlikview and I need to show in the pivot table % of sales for each row.  See attached screenshot.

For example I am wanting to create a new column title % of sales, it will take each row and divide it by the total of the Title Row "Sales".  See the attached file called excel.

[Jason_Michaelides]

Hi,

Assuming your expression in the amount column is Sum(Amount) then try Sum(Amount)/Sum(TOTAL Amount) as the new expression for percentage.

Hope this helps,

Jason

[Jason_Michaelides]

Oops - sorry just re-read the question!

Try Sum(Amount)/Sum({<Title={Sales}>}TOTAL Amount)

Jason

[#4]

Jason,That worked, but I need a bitmore.  It works great when there is one year in the column, but when I have more than one year not quite working.  How can I get this to only percentage of a that one colum.See attached.

[Jason_Michaelides]

Try Sum(Amount)/Sum({<Title={Sales},Year=>}TOTAL Amount)

[#6]

Getting a little bit closer.  First I can't thank you enough for the help!!.  It is know calculating the percentage on all the, I just want it to calc for that specific column, so if I just choose 2012, it will calc on 2012.  If I choose 2011 and 2012, it will calc the sales on2012 only for that column and 2011 only on that colum.  I have attached a screen shot of how excel pivot table does it.THANKS

[Jason_Michaelides]

Have you added Year as a dimension?

[#8]

Yes year is a dimension

[Jason_Michaelides]

Then I'm not sure why the first answer I gave isn't working.  Can you post your app at all?

[Jason_Michaelides · Accepted solution]

Oh - hang on!  Try:

Sum(Amount)/Sum({<Title={Sales}>}TOTAL <Year> Amount)