Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try with :
sum(REC_COUNTER_DT) / sum(TOTAL <Year> REC_COUNTER_DT)
Thanks, that worked perfectly!
John