I want to see % in rows for each column in a pivot table.
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.