"I am creating Performance Analytics dashboards using indicators and data sources for the contract table to track monthly costs based on the start and end dates. I need to calculate the total monthly cost for each year and sum it across multiple contracts.
For example, consider the following contracts:
- Contract A:
- Contract B:
- Start Date: Jan 2025
- End Date: Dec 2026
- Payment Amount: $100/month
- Calculation:
- 2025 Total: 12 × $100 = $1,200
- 2026 Total: 12 × $100 = $1,200
- Start Date: Mar 2025
- End Date: Feb 2026
- Payment Amount: $200/month
- Calculation:
- 2025 Total (Mar–Dec): 10 × $200 = $2,000
- 2026 Total (Jan–Feb): 2 × $200 = $400
Expected Report Output:
YearContract AContract BTotal Cost
2025 | $1,200 | $2,000 | $3,200 |
2026 | $1,200 | $400 | $1,600 |
Additionally, if I select a specific vendor, the report should sum all contracts associated with that vendor and provide the total cost per year.
