Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
CerebosSA
Contributor
Contributor

I need my contribution % to remain unchanged when applying a selection

I am unsure how to edit my expression, to enable my contribution % to remain unchanged, after a selection. e.g Store Contribution.PNGBefore the selection 0.02% ,after selecting the store the contribution is a 100%. 

sum({$<Year= {$(vMaxYear)}>}$(vMeasure))
/sum({$<Year= {$(vMaxYear)}>}total $(vMeasure))

2 Replies
sunny_talwar

May be this

sum({$<Year= {$(vMaxYear)}>}$(vMeasure))
/sum({$<Year= {$(vMaxYear)}, [Store Name]>}total $(vMeasure))
CerebosSA
Contributor
Contributor
Author

Thank you very much! 🙂