I would like to use a static variable for a % calculation, so that when filters are applied, the denominator will stay static. The issue that i am facing is that i would like the static variable to be static based on the local market and not the sum for all local markets.
Such as below:
Please let me know if this is possible using the static variable, and if not, please advise if there is another way i can achieve this.
All the best,