Is it possible to divide column totals?
I am looking for a way to divide the totals of two columns to display as a big number. In the screen grab below I have a small dataset that I want to display in a report. I need the total cases (Column 2) the total emergencies (Column 4) and I need to know the percentage of emergencies that were responded to in 6 minutes or less (column 6). So based on this small dataset I could say "In 2020 we had a total of 4 cases; 2 of which were emergencies and we responded to those emergences in under 6 minutes 50% of the time".
I have tried to do an advanced function on column 6 ("Division By Column") and also tried set analysis but neither gives me the value I am expecting. Any help would be greatly appreciated