Dimension

[smilingjohn]

Hi ALl,

In Dimension i have a field called " Depaertment "

now i wat to display the Departments for the Max date of "Date" field ..

How to wright this in Calculated Dimesion ..

Will it be like this ?

max(Date),Department

Please provide siggestions ..

Thanks in Advance

[Anil_Babu_Samineni]

What are you getting when we write like below?

=Date(Max(TOTAL Date))

OR

=Aggr(Date(Max(TOTAL Date)), Department)

[smilingjohn]

Hi Anil sir,

for this below

=Aggr(Date(Max(TOTAL Date)), Department)

Iam getting max of date ...no data

Iam using only Fields in a straight table and there is no expression for this ..

Just wanted to show the detial table..

For all the dimensions i want to show only those recorde which were uodated for max date..

Thanks

[Anil_Babu_Samineni]

Not sure, I understand your concern here. will you able to explain with data set?

[devarasu07]

Hi,

Method1:

=Aggr(Date(Max( Date)), Dept)

[its_anandrjs]

You can use SET analysis for this

Ex:-

Dim:- Department

Dim:- Date

Count({<Date = {"$(=Max(Date))"}>} Date)

[imrasyed]

Hi John,

Can you try using the below expression in Text object

=Only({$<date={"=max(Date)"}>}Department)

[PrashantSangle]

Adding to Anand solution you can try below

Sum({<Date = {"$(=Max(Date))"}>} 1)

Regards,

[smilingjohn]

Hi Anil,

OKay

Iam using a straight table which will show the detailed table and it will contain only field names like

Department, Name, City, Sponsoror,and so on.  there will not be any expression for this

Now i want to diplay all the details of the fields in chart for max of "Date"..

IJust wanted to how do i achieve this ?

[antoniotiman]

Hi John,

may be like this