Date Dimension

[AleCruc94]

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

[Kashyap_R]

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

[AleCruc94]

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)..

[Kashyap_R]

Hi

Try this

Aggr(MAx(Date),Status)

Thanks

[AleCruc94]

in this way I have just the data and not the status

[Kashyap_R]

Hi

Can u please share the QVF, I will try and get u back

Thanks

[tresesco]

Try like:

Dimension:          Date(Max(Total Date))

Exp:                         FirstSortedVaule(Status , - Date)

[AleCruc94]

I have upload the qvf do U see it?

[AleCruc94]

sorry and this is the excel needed

[Kushal_Chawda]

may be this

Dimension:  Date(aggr(Max(total Date),Date))

Expression: FirstSortedVaule(Status , - Date)