hi apolgies i posted yesterday
i have data by date , by category and by location.
i am hoping for help with being able to just return the daily data in the front tab based on a date drop down (see data tab), by category type and location and also at a total level.
and then to sum up to a YTD position ( see data is split into M T W T F based on the date) but if i wanted the daily data as at 26/3/20 and also the YTD data (23/3/20 to 26/3/20)
hoping someone may be able to please assist with this!
i have data by date , by category and by location.
i am hoping for help with being able to just return the daily data in the front tab based on a date drop down (see data tab), by category type and location and also at a total level.
and then to sum up to a YTD position ( see data is split into M T W T F based on the date) but if i wanted the daily data as at 26/3/20 and also the YTD data (23/3/20 to 26/3/20)
hoping someone may be able to please assist with this!