Filter restriction using alternate state variables.......?
Hi Friends,
I have a requirement to display the comparison of 3 different brands.So for that I have created 3 alias for the brand i.e brand1 and brand2 and brand3 in script level
select Brand_id,
Brand,
Brand as Brand1,
Brand as Brand2,
Brand as Brand3,
from brand_table;
and then created 3 alternate states as StateA, StateB and StateC and then created 3 list box for three different brand's.
and then StateA applied to Brand1 and StateB applied to Brand2 and StateC Applied to brand3
then created 3 pie charts for 3 individual brands and I have another 4 filters apart from brand filter. I want to apply only three filter to the pie chart and fourth filter should not effect the pie chart.
For getting the 3 filters applied to the pie chart I made alternate state in the properties tab as default state for the pie chart and for the rest three filters applied the below Expression in the chart level.
Expression used to define the Pie chart sum({$*[StateA]} Revenue)//$
Currently when i select the fourth filter charts are not displaying.
How can i make pie chart independent of the 4th filter selection......?
