Hi there all.
Here is my challenge.... i have a pivot table with names along the top and the value is 'Y' or 'N'. I want to show the % of each value against the top row, while keeping the original values. I have attached a sample of the raw data but in reality i have thousands of rows so simple sorting is difficult. The end result that im looking for is to see what % of 'N' & 'Y' for each member name. i would like to see the 75% & 25% built into the pivot table somehow.
any thoughts?
raw data looks like this
Here is my challenge.... i have a pivot table with names along the top and the value is 'Y' or 'N'. I want to show the % of each value against the top row, while keeping the original values. I have attached a sample of the raw data but in reality i have thousands of rows so simple sorting is difficult. The end result that im looking for is to see what % of 'N' & 'Y' for each member name. i would like to see the 75% & 25% built into the pivot table somehow.
any thoughts?
raw data looks like this