How to generate missing data in month wise.I have day level data.I need to show count based on the filters.
cust_id
dept
sub dept
max_amount
Date
id
101
emp
xyz
400,000.00
6/1/2018
1001
102
emp
xyz
400,000.00
6/1/2018
1001
103
IT
xyz
400,000.00
6/1/2018
1001
105
HR
xyz
200,000.00
9/24/2018
1002
result: if I select june1 I need to show customer count as 3, if I select dept as empI need to show the customer count as 2.
above count 3 and 2 should repeat for next months also(like id I select dept as empcount is 2 and if I select dpet as IT should show count as 1 for fallowed month until receive the data from database.
how to achieve this requirement.please help me ASAP.
