Got a tricky one, I want to create a pivot table starting with a column of percentages on the left, so for example the first column of the table will be:
25% (Count)
33% (Count)
50% (Count)
The idea being to count how many 50%s there are, how many 25%s etc. Problem is, all of my numbers aren't integers, so I actually have 25.1%, 25.14%, 25.6% etc which leaves my pivot table like this:
25%
25%
25%
25%
33%
33% etc then a count of all the specifics. Is there a way to get the pivot table to ignore everything after the decimal place?
I then want more info to work out some averages of all the values attached to those initial percentages. This works fine, however on some I am doing calculations with zero, giving me "#DIV/0!" and consequently the same value in the pivot table. Is there a way I can exclude that value from counting for just that particular average?
Cheers,
25% (Count)
33% (Count)
50% (Count)
The idea being to count how many 50%s there are, how many 25%s etc. Problem is, all of my numbers aren't integers, so I actually have 25.1%, 25.14%, 25.6% etc which leaves my pivot table like this:
25%
25%
25%
25%
33%
33% etc then a count of all the specifics. Is there a way to get the pivot table to ignore everything after the decimal place?
I then want more info to work out some averages of all the values attached to those initial percentages. This works fine, however on some I am doing calculations with zero, giving me "#DIV/0!" and consequently the same value in the pivot table. Is there a way I can exclude that value from counting for just that particular average?
Cheers,