I have two dimensions Key and Date and one measure sales.Each key has one date and null values. The problem is sales data is available only for null value.
I want to show both date(Excluding nulls) and max(sale) for the keys in the table.
The issue is if i filter null values for date i get null for max (sales) because sales data is only available for null dates,How do i show both max(sales) and date together in table.
Can i do some 'aggregation' on date over key so that i dont exclude null dates(maybe something like Aggr(Date(Max(Date)),Key) )??