Max date for a location

[davyqliks]

Hi,

In a table with Location as a dimension and 

Date(Max([%VoucherDate]))

as the expression i am getting a correct return for each of the locations showing the latest date imported.

I am trying to display this in separate charts so i use the following:

enable conditional Dimension of Location as

sum({<Location={LTR}>}Location)

with the expression

Date(Max([%VoucherDate]))

But this is not pulling the correct date

How can i show the max [%VoucherDate] for a fixed [Location] of LTR 

Am i using the enable conditional Dimension correctly here?

Thank you in advance, any help/suggestions would be very appreciated

[lironbaram · Accepted solution]

hi 

use location as the dimension

and use this expression: 

Date(Max({<Location={LTR}>}[%VoucherDate]))

[davyqliks]

Hi,

Thank you so much....Giving this a try now and will report back shortly.

Much appreciated 

Daniel

[davyqliks]

Hey there,

This worked 100% as required, thank you so  much

regards,

Daniel