Subtotal by only 1 expression

[qlikviewaf]

Hi,

i build the following table, as you can see we have 3 expressions: Revenue / Surgery / ASP.

How i can add a total by customer only for Revenue? If i turn on subtotal using table-proprierties, the subtotal will appear for all the 3 expression, and i would like to have it only for revenue.

THank you

[Brett_Bleess]

I do not know that it is possible to do what you want to do, I would suggest having a look at the following Design Blog post though, as that may provide another option in a separate chart.

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

Regards,
Brett