Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

bhavvibudagam
Contributor II

Pivot table Total

Hi Experts,

Can any one please help me on this.

In the below pivot table I have enable total at Month column. Its giving Total as 393 but when we sum 113+358+687 will get 1158.

Please let me know is there any way to resolve this.

Thanks in advance.

3 Replies
siddharth_s3
Contributor

Re: Pivot table Total

Change total functions from auto to sum

bhavvibudagam
Contributor II

Re: Pivot table Total

Hi Siddharth,

I haven't found that option for Auto to Sum under Month only able to see Total Label on below.

Could you please add the screen shot or any sample app.

Thanks in advance.

siddharth_s3
Contributor

Re: Pivot table Total

Oh, that's an option of straight tables not pivot. My bad.

I think the pivot does whatever is there in the master measure

Community Browser