Forum Discussion
Solved
Need help on Dynamic Title based on date range
Hi Everyone,
Heed help of Dynamic Title based on date range filtered in slicer.
For example, if i select the date range as from 01/04/2019 to 15/04/2019 then the title should display as
"Sales report for the period 01/04/2019 to 15/04/2019".
My sales data is as follows
| Sale Date | Item | Units | Total |
| 01/04/2019 | Pencil | 95 | 189.05 |
| 02/04/2019 | Binder | 50 | 999.5 |
| 03/04/2019 | Pencil | 36 | 179.64 |
| 04/04/2019 | Pen | 27 | 539.73 |
| 05/04/2019 | Pencil | 56 | 167.44 |
| 06/04/2019 | Binder | 60 | 299.4 |
| 07/04/2019 | Pencil | 75 | 149.25 |
| 08/04/2019 | Pencil | 90 | 449.1 |
| 09/04/2019 | Pencil | 32 | 63.68 |
| 10/04/2019 | Binder | 60 | 539.4 |
| 11/04/2019 | Pencil | 90 | 449.1 |
| 12/04/2019 | Binder | 29 | 57.71 |
| 13/04/2019 | Binder | 81 | 1,619.19 |
| 14/04/2019 | Pencil | 35 | 174.65 |
| 15/04/2019 | Desk | 2 | 250 |
| 16/04/2019 | Pen Set | 16 | 255.84 |
| 17/04/2019 | Binder | 28 | 251.72 |
| 18/04/2019 | Pen | 64 | 575.36 |
| 19/04/2019 | Pen | 15 | 299.85 |
Thanks in advance.
Best Regards,
Shib
2 Replies
Hi,
I think this answer is only correct if the data in Sheet1 has a record for the filtered start and end date so it does not give the correct result if we filtered from 1-Sep-2021 to 17-Sep-2021 and Sheet1 only contains data from the 2-Sep-2021 to 16-Sep-2021 as this would give the results of " Sales report for the period 2-Sep-2021 to 16-Sep-2021" .. which is clearly not show the filtered date range.
