Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a date field in dimension in straight table and I wan to use max date but max function no working in if condition on date.
It's like I want to show products for max date in straight table.
What to do?
Thanks
Saurabh
Hi,
Try like this
Dimension: Product
Expression: Date(Max(Date))
OR
Displays the list of products which exists on max date.
Dimension: Product
Expression: Only({<Date={'$(=Max(Date))'}>} Date)
Hope this helps you. If this is not you are expecting come up with some sample data and expected output.
Regards,
Jagan.
HI,
Look at firstsortedvalue() Function
Regards
ASHFAQ
use this =FirstSortedValue(Products, -[DateDim])
Hi,
Try like this
Dimension: Product
Expression: Date(Max(Date))
OR
Displays the list of products which exists on max date.
Dimension: Product
Expression: Only({<Date={'$(=Max(Date))'}>} Date)
Hope this helps you. If this is not you are expecting come up with some sample data and expected output.
Regards,
Jagan.