2 of 2 people found this helpful
wow your workbook is complex
and you have a different date field for each of your measures - I'm not certain I understand the goal but your individual last dates can be found with 4 formulas like this
Now comes the problem - there are 4 different date fields that really don't know one another - it you require creating a single continuous date frame and associating each or your dates with that continuous frame - see scaffolding
don't know if you are looking at these 4 areas independently or combined - if they are individual you can use the above formulas - if you want to look at a combined result the solution is much more complex
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Is there a way of using this to calculation to filter the view?
1 of 1 people found this helpful
that depends on what you are trying to do
if all you want to do is know the sales on the last day by sub category
You can do something like this
but that is the only data you have - 17 marks - if you wanted to do any sort of YOY or running totals you would have to take a different route
I can't see the second picture unfortunately, but I am trying to show a single day (or date range) showing the most recent entry to a spreadsheet based on data being in a particular column:
In a nutshell, I am trying to get it to show me the 22st of December based on the fact that was the last date any data was entered, but the dates themselves run to the end of the year. And have this as a view that updates daily, based on the refreshing of the spreadsheet?
Any ideas would be much appreciated! Your formula above works in pulling the date back, now I just want that date in the view.
I'm sure you'll figure it out