Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have multiple charts in a sheet. I want to apply some dimension based filter for each chart. For Chart 1 should always show Asia data, Chart should should always show Europe data and so on.
Anyway this can be achieved ?
Yes this is possible. you need some set analysis within you charts.
Set analysis looks like this:
Sum({<filterfield={'filter'}>} Measures field)
for you it can be something like this
Sum({<Country={'Japan'}>} Sales)
note: please only use set analysis in Measures. If you use them within dimensions you create a calculated dimension, it is best to avoid this.
see link to set analysis
If this helped out, please like the post and accept this answer a the correct one
Yes this is possible. you need some set analysis within you charts.
Set analysis looks like this:
Sum({<filterfield={'filter'}>} Measures field)
for you it can be something like this
Sum({<Country={'Japan'}>} Sales)
note: please only use set analysis in Measures. If you use them within dimensions you create a calculated dimension, it is best to avoid this.
see link to set analysis
If this helped out, please like the post and accept this answer a the correct one
@MartW Thanks a lot