I want to see % in rows for each column in a pivot table.

[Anonymous]

Ex. rows with % ethnicity with columns of years. I want % for each year of each compared to total for the year/semester. I want to see multiple years. As example below shows I'm getting % of total for all selected years/semesters. I want each % column to sum to 100%.

My expression is

sum(REC_COUNTER_DT) / sum(total REC_COUNTER_DT)

How can I fix this? I know I can select just one semesters and it works, but I want to see multiple semesters.

John

[sergio0592 · Accepted solution]

Hi,

Try with :

sum(REC_COUNTER_DT) / sum(TOTAL <Year> REC_COUNTER_DT)

[Anonymous]

Thanks, that worked perfectly!

John