Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Worked Perferctly, THANKS!!!!!
Coolio.
I'm using the % of function in a P&L Pivot table, but it's only calculating the base amount as a %, everything else = #N/A. How do I correct this?