Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

nikhilgarg
Contributor III

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
Contributor III

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

You can Enable Total function in the SBUNAME Column.

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

3 Replies
sibin_jacob
Contributor III

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

You can Enable Total function in the SBUNAME Column.

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

sibin_jacob
Contributor III

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

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
Honored Contributor II

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

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

Community Browser