Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
nikhilgarg
Specialist
Specialist

Showing 'Totals' at vertical level in Pivot table-Qliksense

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

1 Solution

Accepted Solutions
sibin_jacob
Creator III
Creator III

You can Enable Total function in the SBUNAME Column.

It will show the 'Total'  as first column before Central column.

View solution in original post

3 Replies
sibin_jacob
Creator III
Creator III

You can Enable Total function in the SBUNAME Column.

It will show the 'Total'  as first column before Central column.

sibin_jacob
Creator III
Creator III

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.



agigliotti
Partner
Partner

if you enable "Show totals" under your dimension (must be the first one), you should achieve it.