Individual Column Total from pivot table

[deekey2]

Hi All,

I created a pivot table as below. And I would like to calculate the % of each column so I tried to get the total of each column first. But when I use Sum(Total QTY) to get column total(e.g. 147 as below), it shows the sum of all columns total(e.g. 43,418).

And I expect to sum the column total like

first column NC01 >  15+44+25+34+18+6+5 = 147

Any suggestions? Thanks a lot.

[NitinK7]

Might be there duplicated values in your data table, please check once

[deekey2]

checked, no duplicated values.

seem Sum(Total QTY) returns total QTY of all cells..

[NitinK7]

if possible can you please share your QVF file with only this single table

[deekey2]

Thanks. I found why...

As you read the following output, it is prefect when I don't filter out "Type=D" in table 1..

but in my case, I expect to display D and E only(e.g. table 2), and calculate the individual column %, any suggestions?

I attached the QVF for you reference..

Regards,

[NitinK7]

I didn't understand 

calculate the individual column %.

if possible can you share with example what you actually want?

[NitinK7 · Accepted solution]

find the QVF and table 3

for Type column I have wrote set expression, might be you want like this

and there seems there allready individual column % are  calculated