Only one Total required in Pivot Table Expression with multiple Dimensions using Partial Sum

[bo1980]

I have Pivot Table with 3 Dimensions and 2 Expressions - a number and a percentage. I'm using Partial Sum to get the Total at the bottom (in green), but I only want the number total. How can I remove / hide the percentage total?

Thanks for any help!

[anushree1]

The attached file is having security constraint as it has section access could you please share a version without section access

[bo1980]

I've updated the attached qvw

[anushree1]

Please check if the attached works

[bo1980]

Although its got rid of the data, I want the row to be removed completely for %

[anushree1]

Partial sums are grouped at the Dimension Level so a place holder will get created for each expression.

So I dont think it could be removed