Hi Team,
Please help me out in this
| Cname | Log in date | Modified date | Booking Date | Disbursement date |
| Jack | 06-02-2020 | 06-02-2020 | 07-02-2020 | 11-02-2020 |
| John | 01-02-2020 | 02-02-2020 | 05-02-2020 | 06-02-2020 |
| Mat | 01-01-2020 | 02-02-2020 | 05-02-2020 | 06-02-2020 |
| Sam | 10-01-2020 | 02-02-2020 | 05-02-2020 | 08-02-2020 |
I have a Data in which i want to make a pivot tables
1.Date wise
2.Overall
If I add date picker I am getting the proper table for 1.Datewise.
But for 2.Overall there is discrepancy.
I need like if the date range selected in the date picker is (log in date) i.e from 2nd feb to 11th feb I am getting values
for count(Disbursement date) = 2 as the Log in date is created in feb
But for overall i need the data irrespective of the log in date I need to count the Disbursement date if it falls within the selected range in date picker.
for Overall I need count(Disbursement date) = 4
