I have a few columns as below
Data Store: ABC, XYZ, '' (Blank)
Location: India, US, '' (Blank)
Refresh Frequency: Planned, Daily (Both values are associated to the above Location)
What I require: to be able to to show Refresh Frequency (text object single text value), by selecting Location. and Excluding Data Store column.
It works fine without the data store column which recently came into picture.
My code: aggr(only({1<Data Store=>}Refresh Frequency), Refresh Frequency)
This works, but as soon as I select anything in the Data Store, the output becomes blank
Is there some issue in Excluding the column ?
Request your guidance
Thanks,
Swapneel
