Total with a calculated expression

[qlikviewaf]

Hi Guys,

i created the simple table below, and i added a calculated dimension "%Calc" which is (Quantity Evolution)/(Quantity Advance).

i want only to have one total row for the "%Calc" dimension, since the "%Calc" inside the Brand Dimension doesn't make sense.

Anyone knows how to achive this?

Thank you

[sunny_talwar]

No direct way to do this within QlikView, but there are some work around to do this. For example, see here:

Pivot Table Partial Percentage