I have a stacked bar chart with all measures summing up to 1. I would like to use the custom max expression to set the max to 1. I don't want to use static max value because the max might change later. I have tried max(Sales_Pct) without success. Please give me some suggestions!
Hi Santhosh, that doesn't work because my bar chart is across time. Say I have 10 bars, then sum(Sales_Pct) = 10 but I need it to be 1. I tried =avg(sum(Sales_Pct)) but that doesn't seem to work as well... any suggestion?