Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Might be there duplicated values in your data table, please check once
checked, no duplicated values.
seem Sum(Total QTY) returns total QTY of all cells..
if possible can you please share your QVF file with only this single table
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,
I didn't understand
calculate the individual column %.
if possible can you share with example what you actually want?
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