How to show only max date values?

[#1]

Hi,

I have data as below in excel.

NO	From	To	Name	date
432434	Sales	Funcorner	XX	06/05/2015   12:56
432434	Sales	Funcorner	XX	12/06/2015   15:04
432434	NO	Road Tax	XX	12/06/2015   14:30
432434	Workshop	Road Tax	XX	13/04/2015   16:15

I need table to show max date when To ='Road Tax'  (in this case the table should show 12/06/2015 14:30) and max date when To ='Funcorner'  (in this case the table should show 12/06/2015 15:04)

Please can anyone suggest me how to do this.

Thanks.

[avinashelite]

try like this in the chart:

Aggr(max(date),to)

where date and to are the column names

[#3]

I always do it in the load script by using the Max statement.

I haven't figured out a better way as yet.

[#4]

Thats a better way than mine!

[#5 · Accepted solution]

Take dimension as 'To' and expression as max(date). This should work i guess.

[avinashelite]

Hi Peter,

If do not require the data slicing to the nth level ,we can always reduce the data in the script itself that a better way but if you don't want the data to reduce we can handle it in the front end

[#7]

Thanks. will this work if there are multiple NO values?  I have tried it. it is showing over all max date values. when I click individual NO values table is showing blanks.

[#8]

Thanks. tried this and it worked.

[avinashelite]

but if you have multiple dimension it might not work properly !!

[#10]

Thanks. would it work if use in script?  please let me know