Hi, all. I'm looking to make a calculated field in a pivot table that can be used to show the percent of scores that are 100 (the Score field can have values from 40 to 100).
I thought this might work: =IF(Score = 100, 1, 0) - but no such luck.
What I really want is to be able to make some buckets of my data. <98, 98 to <100, and 100 - then use the pivot table to display a pivot table & pivot chart to show the % of scores that are in the various buckets over time.
Thanks!