Hello!
I am having trouble with my Pivot Table Values. I need to calculate the percentage of a "Count of" field with an "Average of" field, but I can't figure it out. I'm not sure if the issue is with the Value settings or the way my data is entered.
Example:
I want to find the percentage of infractions for each day compared to the total routes for each day (using the pivot table)
Data set:
Date Infraction Total Routes that Day
5/1 ABC 125
5/1 DEF 125
5/1 ABC 125
5/2 DEF 200
5/2 GHI 200
Hopefully that makes sense. Thanks.
I am having trouble with my Pivot Table Values. I need to calculate the percentage of a "Count of" field with an "Average of" field, but I can't figure it out. I'm not sure if the issue is with the Value settings or the way my data is entered.
Example:
I want to find the percentage of infractions for each day compared to the total routes for each day (using the pivot table)
Data set:
Date Infraction Total Routes that Day
5/1 ABC 125
5/1 DEF 125
5/1 ABC 125
5/2 DEF 200
5/2 GHI 200
Hopefully that makes sense. Thanks.
