Solved

[microwin88x]

Solved

[sunny_talwar]

Right now you have two expressions, to do what you are looking to do, you will need to use a single dimension (with pick(match...)) and then use a single expression. There are many examples of how this can be done, but if you want to see how this can be done for your case, you will have to provide a sample so that we can help you better

[microwin88x]

Would I get the same result if I use a single dimension and expression?

I've attached a screenshot with the expected result. Thank you!

[sunny_talwar]

You can get the same result, but the calculations will change a little

[qliksus]

You can add a dummy Calculated Dimension and name the Total lable in the presentation tab to % and check the Show partial sum for this dummy dimension

and in the Expression you can disable your Second Expression and use to Dimensionality to calculate the % value

[sunny_talwar · Accepted solution]

I think we did manage to resolve this here: Pivot Table - Show only Subtotal for Expression (Without Rows)

microwin88x I suggest closing this thread by marking assumed answer and any helpful responses so that people like us, who are willing to help can focus on threads where they might be needed more.

Best,

Sunny