Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need to have a pie chart by región, but any time i do a selection in any region i need this chart not changing, It is that possible?
Thanks a lot!
SUM({<Dimension1 = , Dimension2 =, Dimension3=,>}Sales)
Considering that you have Dimension1, Dimension2, Dimension3, are list boxes and you don't want your pie chart to be changed on selecting any selection from these list boxes.
Other solution is SUM({1}Sales)
Already suggested by Chiranjeevi
Yes.It is possible using setanalysis.
ignore region from this chart
Ex : Sum ( {<Region=>} sales)
if you want that chart won't be responded to any selections then
Ex : Sum({1} Sales)
SUM({<Dimension1 = , Dimension2 =, Dimension3=,>}Sales)
Considering that you have Dimension1, Dimension2, Dimension3, are list boxes and you don't want your pie chart to be changed on selecting any selection from these list boxes.
Other solution is SUM({1}Sales)
Already suggested by Chiranjeevi
Region dimension
Sales is expression
To show sales per region use the below set analysis syntax in sales expression in expression tab.
Sum({$<Year={$(=Max(Year)), $(=Max(Year)-1)}>} Sales / $(vCurrency)).
Hope this helps