Total a measure in dimension side of a pivot table?

[user467341]

Hi everyone, is it possible to add a dimension total at the dimension side of a pivot table in Qlik Sense?

For example,

Expected output

where there is a "Final column" in the dimension side.

Or what is the alternative to have a grand total according to the order/company grouping?

[vinieme12 · Accepted solution]

 Add a Calculated Dimension after Year As below

=    Aggr ( Sum(  Sales  )  , Order ,Company, Year )

[user467341]

Didn't know I have to start with Aggr... Thanks!