How to only display CURRENT details

[hopkinsc]

Hi, I am trying to create a chart that displays CURRENT stock levels of products in our retail stores. I only want to display the latest record regardless of the date selected but users can make other selections such as Retiler or Dept Name etc.

I am guessing it would use the latest file received and processed going by the date field (which is StoreDate)

Basically i want it to ignore any selection to do with date (any made from the top row), but i want it to use any selction made from the left hand side.

I have attached a sample of my document.

Can anyone help me please?

Thanks in advance.

Chris

[montubhardwaj]

Hi,

Your Date field sems to have some issue. But you can try the below:

Create a variable named "vlatestDate" and assign this expression to it:

Max(Date(StoreDate,'DD/MM/YY'))

Then this variable will hold always the latest date which avaliable in your application.

Now, you can go ahead with Set Analysis as usual and put the below condition:

Sum({$<StoreDate = {$(vlatestDate)}>} StockQuantity)

Hope this will help you!

Regards,

Sharma

[#3]

Hi,

Check this one out.

Regards,

Jonathan