Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
i am trying to create a table with two columns and just one row: i want a row where i have the status of revenues at the maximum date
in my case the filed is 'status' and the record 'Validated' so the output should be :
data , status
maximum(Date) , validated
but when i try to use in the table the Dimension =Date(Max(DataPL)) it does not work,.
Any suggestions?
Thanks in advanced
Alessandra
Hi
when we use aggregation it will be considered as measure so you have to give it as measure.
Go to presentation and unselect total, only if you don't want the total row.
Hope this helps
Thanks
yes ok, in this way it works!
but If I want just the status as the maximum date would be included? (as in a sort of the set analysis but with a dimension)..
Hi
Try this
Aggr(MAx(Date),Status)
Thanks
in this way I have just the data and not the status
Hi
Can u please share the QVF, I will try and get u back
Thanks
Try like:
Dimension: Date(Max(Total Date))
Exp: FirstSortedVaule(Status , - Date)
I have upload the qvf do U see it?
sorry and this is the excel needed
may be this
Dimension: Date(aggr(Max(total Date),Date))
Expression: FirstSortedVaule(Status , - Date)