S
snigam
i created a calculated firled in my pivot table, but the for the grand total
column it is not calculating. it is calculating in all the other areas, just
not the grand total columns. here is what it looks like: as you can see the
#DIV/0! , the calculated field formula is Column C = (column A-Column
B)/Column B it should state -0.5802 ((Same for Column F=(column D-E)/E)
this should be -0.7284)
A B C D E F
18752 44671 #DIV/0! 10542 38821 #DIV/0!
column it is not calculating. it is calculating in all the other areas, just
not the grand total columns. here is what it looks like: as you can see the
#DIV/0! , the calculated field formula is Column C = (column A-Column
B)/Column B it should state -0.5802 ((Same for Column F=(column D-E)/E)
this should be -0.7284)
A B C D E F
18752 44671 #DIV/0! 10542 38821 #DIV/0!