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% | | |
