Hello,
I have been charged with creating an interactive pivot chart which calculates the frequency of census values. What I have done is used the census table to generate a census per day. From that I am trying to get frequency. To thwart confusion, frequency is defined as the number of instances of the census value occurring within the desired range. So for the following table let's use the following example. I wrote a frequency into a table using the following formula type to match the table below: =(COUNTIF($C$2:$C$10,C2)/Counta($C$2:$C$10))
<tbody>
</tbody>
So how might one make this happen in a pivot table? Thank you for your help here in advance.
****** id="cke_pastebin" style="position: absolute; top: 244px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
I have been charged with creating an interactive pivot chart which calculates the frequency of census values. What I have done is used the census table to generate a census per day. From that I am trying to get frequency. To thwart confusion, frequency is defined as the number of instances of the census value occurring within the desired range. So for the following table let's use the following example. I wrote a frequency into a table using the following formula type to match the table below: =(COUNTIF($C$2:$C$10,C2)/Counta($C$2:$C$10))
Year | Month | Census | Frequency of Census |
2014 | May | 1 | 11% |
2014 | May | 4 | 11% |
2014 | May | 7 | 33% |
2014 | May | 6 | 22% |
2014 | May | 6 | 22% |
2014 | May | 7 | 33% |
2014 | May | 2 | 22% |
2014 | May | 7 | 33% |
2014 | May | 2 | 22% |
<tbody>
</tbody>
So how might one make this happen in a pivot table? Thank you for your help here in advance.
****** id="cke_pastebin" style="position: absolute; top: 244px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">