calculated field for percentage in pivot table

G

Gerardo

how can i calculate the percentage based on the filtered total of a given
field?
Example; if i have 3 fields and use one value to filter fields 1 and 2, then
calculate a column with the percentage of every value based on the total of
that filtered data

Thank you, regards
 
D

David Heaton

how can i calculate the percentage based on the filtered total of a given
field?
Example; if i have 3 fields and use one value to filter fields 1 and 2, then
calculate a column with the percentage of every value based on the total of
that filtered data

Thank you, regards
Click to expand...

I'm not sure i understand what you are trying to do.

Are the 3 fields you have column/row fields or values?

A more detailed explanation would be useful

Regards

David
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2002 Pivot Table calculated field percentage. 3
Pivot table calculated field Count(field) / sum(field) 0
Displaying a count as a percentage within subtotals in a pivot tab 1
Calculated Field in a Pivottable 2
Pivot Table Custom Calculations 1
percentage calculation problems 0
Percentage of Count in Pivot 3
Calculated Field in Pivot Table 1

Top