I am trying to make a pivot table using the count of stores. But the % of total row should be by Service.
I tried using the total function, but still, I am not able to use it.
Trying to achieve something like below:
| Legacy Pool | 100.00% | 0.00% | 0.00% | 100.00% |
| Small Parcel Direct | 93.83% | 3.70% | 2.47% | 100.00% |
| Small Parcel Exception | 62.50% | 25.00% | 12.50% | 100.00% |
But on QLik:
| Service | Discrepancy_+/-1? | Match | Overage | Underage |
| Legacy Pool | 5178200% | 2468400% | 7010800% |
| Small Parcel Direct | 9899500% | 4719000% | 13403000% |
| Small Parcel Exception | 761500% | 363000% | 1031000% |
Could someone please help with this. Appreciate your help in advance
