Discussion board where members can get started with Qlik Sense.
In Qliksense, i have a pivot table as attached.I want to show the Totals as a separate column after 'North' column where Total of:
Forecast: Sum for every zone i.e. Central, East and North
Last Day Sales: Sum for every zone i.e. Central, East and North
Var: Sum for every zone i.e. Central, East and North
How can i achieve this? When i checked the "Totals" at dimension level, it is showing me Totals at horizontal level(Bold in the image attached.)
Go to Solution.
You can Enable Total function in the SBUNAME Column.
It will show the 'Total' as first column before Central column.
Another way for custom total
Load Distinct Zone, Zone as Zone1, resident table;
Load Distinct Zone, 'Total' as Zone1 resident table;
then use Zone1 in your pivot table.
if you enable "Show totals" under your dimension (must be the first one), you should achieve it.