Pivot table Total

[bhavvibudagam]

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.

[siddharth_s3]

Change total functions from auto to sum

[bhavvibudagam]

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]

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

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