Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi
use location as the dimension
and use this expression:
Date(Max({<Location={LTR}>}[%VoucherDate]))
hi
use location as the dimension
and use this expression:
Date(Max({<Location={LTR}>}[%VoucherDate]))
Hi,
Thank you so much....Giving this a try now and will report back shortly.
Much appreciated
Daniel
Hey there,
This worked 100% as required, thank you so much
regards,
Daniel