Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am unsure how to edit my expression, to enable my contribution % to remain unchanged, after a selection. e.g Before the selection 0.02% ,after selecting the store the contribution is a 100%.
sum({$<Year= {$(vMaxYear)}>}$(vMeasure))
/sum({$<Year= {$(vMaxYear)}>}total $(vMeasure))
May be this
sum({$<Year= {$(vMaxYear)}>}$(vMeasure)) /sum({$<Year= {$(vMaxYear)}, [Store Name]>}total $(vMeasure))
Thank you very much! 🙂