Hi,
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.
Thank,
Pat
