Id this what you wanted? sales by weekday?
see the attached
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.
Thank you so much Jim for responding.
But my client is looking for day (weekday) level comparison which is little complex for my level.
for example : 1 jan 2018 (monday) Vs. 2nd Jan 2017 (monday) sales
I have come across few posts in this forum which does solve that they only work for one dimension at a time and date range gets limited to one day ata time.
But my requirement is to be able to add more dimensions and have a date range for more than a day.
Attached is what i have achieved so far. (but it has limitation hence i took another approach as shown in the attached workbook)