Advanced Function for Calculating % Against Column
Hi there, I have created a report that shows Property Loss by Year/Quarter. As you can see from the screen grabs, I was able to successfully calculate the % property loss by using the "Percentage Against Column" advanced function. I chose the property loss amount against the property value column. This works perfectly except when I add subtotals (so I am summing by year) I can't figure out how make this column show the summed value of property loss as a % of the summed value of the property value. Any help would be appreciated - thanks!