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
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.
