Hi all,
I have requirement where in we have to always have one of the 3 fields selected.
The 3 fields are YTD, CM and CY ( curr month and curr year). The values are 1 and 0 in these fields.
They are connected to the FACT table through the date_key.
We have list boxes for these 3 field for User Selection. But we need to always have one of these fields selected. By default we can have the YTD as always selected. ( perphaps when clear all is used, it should still default to YTD).
Thanks,
Venu