Hi Folks,
I have question with the Simple list extension function
I have a Filed name called Country in that we have Australia, Canada, Germany, France, India,...………. and soon.
The question is I want to add the dummy value ('ALL') in the field Country
ALL is the (Total of Country)
If we select the filter Germany than Germany values should populate in the water fall chart or where ever the charts are linked to this filter
If we select the filter France than France values should populate in the water fall chart or wher ever the charts are linked to this filter
and soon for the rest of all the countries.
If we select the filter 'ALL' than 'ALL' values should populate in the water fall chart or where ever the charts are linked to this filter
I have tried doing in the below syntax
DIM:
Load *
Inline [
dim
1
2];
in the simple list box I have used the syntax if(dim =1, Country, 'ALL')
The data 'ALL' is added in the list but the problem is where ever this filters are selected all the charts are blinking and getting error
help me with if there is any solution to add a dummy value name called 'ALL'