-
1. Re: Only Display Latest Entry For each Location
Matthew Theis Jan 9, 2018 2:06 PM (in response to Carl Shatraw)2 of 2 people found this helpfulHey Carl Shatraw Including a workbook would assist here greatly.
I think you might be looking for a LOD expression. Try {fixed [location]:max[date]} You could then pull this into a column shelf which will return the latest date per each location. Then pull in measures that you want to report on for that date.
Did this help?
Best,
Matthew
-
2. Re: Only Display Latest Entry For each Location
Teju pamarty Jan 9, 2018 2:15 PM (in response to Carl Shatraw)1 of 1 people found this helpfulHi Carl, you can do this by creating a calculated field.
1) Create a calculated field similar to the following : { FIXED [Location]:MAX([Date])} = [Date]
2) Place the calculated field on the filter shelf and select "True" values.
3) Right click and drag the Date on to the rows shelf and select discrete. Drag the location, product and inventory too on to the rows shelf.
This should give you the required output. Let me know if you have any more questions.