Discussion board where members can get started with QlikView.
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.
Solved! Go to Solution.
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,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.
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