Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
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.)
Thanks,
Nikhil Garg
You can Enable Total function in the SBUNAME Column.
It will show the 'Total' as first column before Central column.
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
NewTabl1:
Load Distinct Zone, Zone as Zone1, resident table;
concatenate
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.