I have done this before and it worked like a charm, but for some reason my expressions are not working like they should this time around.
I created a band that seggregates the amounts into the various categories based on the year. These values were deflated to show a more realistic amount, and then categorized with the dimensions. Now, when I try to produce a percentage based on the column totals within the expressions it does not want to work.
See Results below of what I am obtaining/ This happens for all the year. I've only shown for the one:
sum( TOTAL <Year> RecordNumber)
I would like to take the count(RecordNumber) and divide it by the total of the row.