Master Calendar with multiple dates fields from different tables without linking , i want to do this at chart level. I tried to do that by set analysis but working on single selection not multiple selection
Basically i want to achive this:
| Year |
Count of Policies |
Premium |
Claim Count |
Claim Paid |
| 2019 |
Those are approved in this period i.e Approval Date between 01-Jan-2019 to 31-Dec-2019 |
Those are approved in this period i.e Approval Date between 01-Jan-2019 to 31-Dec-2019 |
Those are Registered in this period i.e Registration Date between 01-Jan-2019 to 31-Dec-2019 |
Those are Paid in this period i.e Paid Date between 01-Jan-2019 to 31-Dec-2019 |
| 2020 |
Those are approved in this period i.e Approval Date between 01-Jan-2019 to 31-Dec-2020 |
Those are approved in this period i.e Approval Date between 01-Jan-2019 to 31-Dec-2020 |
Those are Registered in this period i.e Registration Date between 01-Jan-2019 to 31-Dec-2020 |
Those are Paid in this period i.e Paid Date between 01-Jan-2019 to 31-Dec-2020 |
| 2021 |
Those are approved in this period i.e Approval Date between 01-Jan-2019 to 31-Dec-2021 |
Those are approved in this period i.e Approval Date between 01-Jan-2019 to 31-Dec-2021 |
Those are Registered in this period i.e Registration Date between 01-Jan-2019 to 31-Dec-2021 |
Those are Paid in this period i.e Paid Date between 01-Jan-2019 to 31-Dec-2021 |
| 2022 |
Those are approved in this period i.e Approval Date between 01-Jan-2019 to 31-Dec-2022 |
Those are approved in this period i.e Approval Date between 01-Jan-2019 to 31-Dec-2022 |
Those are Registered in this period i.e Registration Date between 01-Jan-2019 to 31-Dec-2022 |
Those are Paid in this period i.e Paid Date between 01-Jan-2019 to 31-Dec-2022 |
| 2023 |
Those are approved in this period i.e Approval Date between 01-Jan-2019 to 31-Dec-2023 |
Those are approved in this period i.e Approval Date between 01-Jan-2019 to 31-Dec-2023 |
Those are Registered in this period i.e Registration Date between 01-Jan-2019 to 31-Dec-2023 |
Those are Paid in this period i.e Paid Date between 01-Jan-2019 to 31-Dec-2023 |
Sum({<Approval _YEAR = {"$(=GetFieldSelections(Calendar_Year))"}>} Premium)
or
Sum({<Approval _YEAR = {$(=Concat(DISTINCT Chr(34)&Calendar_Year&Chr(34),','))}>} Premium)
Your quick response would by helpful.
