Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I was provided with a pivot table in Excel below to create one similar to it in Qlikview. I am able to do it without percentage column. Do you know if it is possible to add percentage? Thanks.
State | City | A | B | C | D | Total | Percentage |
New York | Queens | 3 | 0 | 0 | 0 | 3 | 4% |
New York | Brooklyn | 1 | 0 | 0 | 0 | 1 | 1% |
New York | Manhanttan | 0 | 0 | 8 | 20 | 28 | 35% |
Subtotal | 4 | 0 | 8 | 20 | 32 | 40% | |
Connecticut | Hartford | 10 | 5 | 1 | 25 | 41 | 51% |
Connecticut | New Haven | 1 | 5 | 0 | 1 | 7 | 9% |
Subtotal | 11 | 10 | 1 | 26 | 48 | 60% | |
Total | 15 | 10 | 9 | 46 | 80 | 100% | |
Percent of total | 18.8% | 12.5% | 11.3% | 57.5% | |||
Percent of New York | 12.5% | 0.0% | 25.0% | 62.5% |
try the approach I used in this post
Partial Sums in straight table | Custom Labels in Pivot SubTotals