PDA

View Full Version : How to divide two values from a pivot table



Johnatha
01-07-2016, 09:10 AM
Hello,

I have created a pivot tables that looks like the following:

Row Labels....Count of People....Count of Aboriginal
BC....167....4
Grand Total....167....4

I want to then add a calculated field that takes the Count of Aboriginal/Count of People. So far I have tried adding a calculated field with no luck. Any ideas?

Thanks in advance!
-Johnathan

mancubus
01-08-2016, 04:58 AM
even though it's hard to visualize your pivot table with the, let's say, 'format' you posted, "calculated item" seems to be your deal.

dont forget to select the colum (or row?) label in order to activate the calculated item button. use items on the right box when writing your formula.