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

[smilingjohn]

HI Devarasu

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

how do i achieve this ?

thank

[smilingjohn]

Hi Antonio ....

There will not be any expression in my chart.

Its just a table to diplay the detailed information..

[vikasdesai]

Hi

Use following Expression

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

[Anil_Babu_Samineni]

Without expression, I don't like to use Max() function. And for your question go to Properties - Presentation - Suppress the null values. You will get it using my condition where i mentioned earlier

[smilingjohn]

This is displaying only max date ...

I want to diplay all the list of department for max date

[antoniotiman]

However, can You provide sample Data and Your expected result ?

[smilingjohn]

HI ANil ,

I used your below suggested Condition and supressed the null values in presentation tab.

But the chart wont display any values...

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

[Anil_Babu_Samineni]

Try first condition then? But i am sure it should work

[smilingjohn]

=Date(Max(TOTAL Date))

in this there is no Department ?

[devarasu07]

Hi,

To get your solution correctly & quickly, always try to share with  mock data and expected output that would be easy for us to check and help you.

Thanks,deva