Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I have seen many thread which you created, And every time you are asking without data only. Make sure, As always you need to prepare one document related the issue. Because we are not of your project..
I am getting, There is no expression in my report? You are not looking this?
What are you getting when we write like below?
=Date(Max(TOTAL Date))
OR
=Aggr(Date(Max(TOTAL Date)), Department)
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
Not sure, I understand your concern here. will you able to explain with data set?
Hi,
Method1:
=Aggr(Date(Max( Date)), Dept)
You can use SET analysis for this
Ex:-
Dim:- Department
Dim:- Date
Count({<Date = {"$(=Max(Date))"}>} Date)
Hi John,
Can you try using the below expression in Text object
=Only({$<date={"=max(Date)"}>}Department)
Adding to Anand solution you can try below
Sum({<Date = {"$(=Max(Date))"}>} 1)
Regards,
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 ?
Hi John,
may be like this