I have three Columns in my report. it looks like this
Member Amount Type
0123 500 Non-Preferred Member
0123 450 Preferred Member
Here Preferred and Non-Preferred Type depends on the object "TYPE" which is being used in the Universe to get this Preferred and Non-Preferred.
This TYPE object always keep on changing (refreshing in backend). So i want to show Member based on Most recent or at whatever time i refresh my report it should give the recent data.
Any suggestions on how to do this???