Set analysis question re line graphs/yearly comparison
I have a calculation of 'utlisation' app which shows the %-age of 'productive' vs 'indirect' labour hours, based on a 'labour type' of I or P.
This works fine so far but I want to extent this to show the productive percentage year on year.
The calculations I have used so far is for '%-Age' is: Sum(LabourHrsExclHoliday) / Sum(TOTAL(LabourHrsExclHoliday)), which correctly shows the breakdown between I and P hours for the selections made.
In a new line graph, I'd like to show on the %-Age (as defined above) for the P hours only, for a range of years. Whenever I have >1 year selected, the figures change as (I assume) the TOTAL function is recalculating.
How do I use Set Analysis (if this is the right approach?) to show results for productive hrs only and have the percentage shown correctly for each year? I've tried doing this in a data table first before I attempt the graph but can't figure out the use of '1' vs '$' qualifier (if that's even what's required)