% of total row pivot table

[sanket94]

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 

[sanket94]

I corrected the data model issue and now works for me.

Thank you so much 🙂