The problem about "Total"

[#1]

I create a pivot table.

But it occurs an issue about the "Show Partial Sums".

I don't know why. Need for help !!!

My pivot table is below:

[ljackson]

Can you upload your file?

[Colin-Albert]

Can you post the expressions you are using on your chart?

[#4]

may help you to attach your app

http://community.qlik.com/docs/DOC-1290

[mjm]

Hello CoCo,

Can you please upload your App so that we can take a look in more depth?

[#6]

Hello,

The attachments are my QVW file and QVD file.

Please have a look. Thanks.

[#7]

Hi,

My App and QVD file are attached.

Please have a look. Thanks.

[jagan]

Hi,

Use Aggregation functions like Sum,

Sum(Col1)

in all the expressions.

Regards,

Jagan.

[NareshGuntur · Accepted solution]

Hi CoCo,

You should use Sum in all the expressions.

Sum(Col1), Sum(Col2).......

When you use this, you'll get the Totals as well but doubled as you haven't dropped the main table. The two tables are getting concatenated.

Please see the attached QVW.

Hope this is clear.

Cheers,

Naresh

[#10]

Hi ,

It works. Thanks too much.