Hi, I have following data and would like to display the data in a Pivot table and filter via DatePicker.
What I want to achieve.
1) The Report by default should displays current month's data.
2) It shall be possible for the user to select a whole month from within the last 12 months by using DataPicker.
3) It shall be possible for the user to select a single day from within the last 12 months by using DatePicker.
So far
1) I have managed to display the data in a Pivot Table.
2) Apply Set Analysis on the Pivot Table to display current months data.
I have not been able to integrate DatePicker. If I display the whole year then I can easily filter via date picker but I am not sure how to handle the default monthly display and using DataPicker together.
Any ideals how to do this...
| REPORT_DATE | CAT | QTY1 | QTY2 | QTY3 | QTY4 | QTY_TOTAL |
| 3/25/2018 | 1 | 80 | 8 | 5 | 0 | 93 |
| 3/25/2018 | 2 | 50 | 5 | 1 | 0 | 56 |
| 3/25/2018 | 3 | 10 | 10 | 5 | 0 | 25 |
| 3/25/2018 | 4 | 30 | 20 | 10 | 0 | 60 |
| 2/20/2019 | 1 | 80 | 8 | 5 | 0 | 93 |
| 2/20/2019 | 2 | 50 | 5 | 1 | 0 | 56 |
| 2/20/2019 | 3 | 10 | 10 | 5 | 0 | 25 |
| 2/20/2019 | 4 | 30 | 20 | 10 | 0 | 60 |
| 1/12/2020 | 1 | 80 | 8 | 5 | 0 | 93 |
| 1/12/2020 | 2 | 50 | 5 | 1 | 0 | 56 |
| 1/12/2020 | 3 | 10 | 10 | 5 | 0 | 25 |
| 1/12/2020 | 4 | 30 | 20 | 10 | 0 | 60 |
