I have a simple stacked barchart for two categories (active and inactive), with columns as bins of age in days, and rows as the distinct count of customer IDs.
I would like to add a ratio of the categories (inactive / active), but I am unable to calculate it because the categories are "isolating" the groups.
For example, if I attempt to SUM(IIF(active='Y',1,0)) and SUM(IIF(active='N',1,0)), I get separate rows for Y and N with one or the other always being zero.
Is there another approach to adding a ratio to this type of chart?
Solved by separating the mark types, thereby removing the link between my ratio calculation (SUM(IIF(active='Y',1,0)) / SUM(IIF(active='Y',0,2))), and the active column value.