Pie chart fixed

[#1]

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!

[chiru_thota]

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)

[MK_QSL · Accepted solution]

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

[Anonymous]

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