I have data that looks like of like this where it's counting individuals that have attribute A or attribute B or both attribute A + B. Basically, everyone counted in the A+B group is also in both the A and B groups.
DDateCategoryDCount11/30/2014A70,51512/31/2014A+B16,69512/31/2014B23,35812/31/2014A71,2961/31/2015A+B16,7881/31/2015B23,525
And I've created a chart that looks like this (added the A/B labels to help illustrate):
I want to try to calculate (and display) the A+B/A percentage value on the chart somewhere. I have no idea how I compare values from separate rows in the data set where the year is the same but the category is different. I don't what the % of total calculation but rather % of just one other value in the table on the same date.
Thank you for your help. I think I've figured it out (I'm getting the correct data anyway).
So, I created a calculated field using the "Total" function:
total(SUM(iif([Category]="CFP FPA Member Count",[D Count],0)))/total(sum(iif([Category]="Total Licensed",[D Count],0)))
Then I tell it to compute using "cell" and it gives me the % back. I've dropped it in the tooltip with a sentence to explain what the % is.
