Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Key | Date | Sales |
---|---|---|
101 | 1-09-2017 | _ |
101 | _ | 232 |
101 | _ | 321 |
102 | _ | 654 |
102 | _ | 342 |
102 | 1-10-2017 | _ |
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) )??
Create a Straight Table
Dimension
1) Key
2) =Aggr(Max(Date),Key)
Expression
Max(TOTAL <Key> Sales)