Skip to Content
0
Former Member
Oct 25, 2010 at 06:07 AM

Dynamic filter to capture the highest value at runtime.

8 Views

Hi,

Is there a way through which we can have a dynamic filter in Deski, which would automatically filter the maximum value from a list of values associated with a dimension object?

I have the following scenario :- I have a dimension object called 'Plan Version', whose list of values would typically be 00, 01, 02, 03.....and so on. These values are updated in the database after every 15 days. Now, in my report, i need to display the data which would be associated only to the highest 'Plan Version' value. This requires me to apply a filter on the highest value of 'Plan Version', which is not a difficult job to do if it has to be a static filter. However, I need it to be a dynamic filter, i.e., every time a new plan version is uploaded in the system, and if the report is refreshed, the report filter should automatically select (highlight) the highest value for 'Plan Version' and display the data accorsingly. One way would be to use the 'Max' function, but aggregate functions cannot be used in complex filters. Is there any workaround for the same?

Any help would be greatly appreciated.

Thanks,

Alok