Hi,
I got a Dashboard to be displayed for different Countries, with dynamic KPI's to be displayed in Chart.
Sample Data:
Country Projections Sales
India Proj_10 1000
India Proj_20 2000
US Proj_10 5000
India Proj_40 6000
India Proj_50 7000
Please note: Projection Fields can be different for country wise.
Requirement:
1. Allow only one country value to be selected.
2. For selected country display ONLY associated or relevant Projection values. Remove unassociated values from Projection List box.
3. The Projection list box values to have the functionality like checkbox so that only one Projection value is selected at a time.
Used List box for Country and Projections.Country List box enabled 'Always one selected value'.
First issue:
(Is there a way we can remove unassociated values from the List box )
Projections List box,shows associated value(Proj_10,Proj_20), but unassociated values are shown in Grey color.
Is there a way we can remove unassociated values from the Projection List box. Option 'Hide Excluded values' is not helping here as still grey color remains.
Second issue:
For Country India, Associated values of Projection List box is Proj_10,Proj_20. When I select one value say Proj_10 obviously the other Proj_20 disappears in the list box. Rather I would like to have this as checkbox. Have set it up using LED Checkboxes under style.
Hence good thing is I could select Proj_10 or Proj_20 or even both and both appears because of checkboxes.
BUT again we would need only one value to be selected in this Projection list box..When 'Always one selected value' and say currently the value is Proj_10 selected, now I could not change the Country list box to US.
Thanks in advance.
Regards,
Avin
