Hi, I need help understanding how to use Pivot Table calcs. I have read a few tuts but they dont appear to give me what I need.
I created a custom field in my raw data , yes or no field based on if the record met a certain condtion.
What I want is a % of one of the conditions based on the total.
So I created a pivot table, 1 Row and put the custom field in the columns, then the count of record in the values.
Name Yes No % Of Yes
Bobby 3 1 66%
I need to create the % of. Any ideas?
I created a custom field in my raw data , yes or no field based on if the record met a certain condtion.
What I want is a % of one of the conditions based on the total.
So I created a pivot table, 1 Row and put the custom field in the columns, then the count of record in the values.
Name Yes No % Of Yes
Bobby 3 1 66%
I need to create the % of. Any ideas?