Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Add a Calculated Dimension after Year As below
= Aggr ( Sum( Sales ) , Order ,Company, Year )
Add a Calculated Dimension after Year As below
= Aggr ( Sum( Sales ) , Order ,Company, Year )
Didn't know I have to start with Aggr... Thanks!