Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If I have data like below:
Data | ||
Time Period | Coverage | Amount |
19-20 | A | 150000 |
19-20 | B | 150000 |
And in my chart I want to display for rolled up Time Period as:
Time Period | Amount |
19-20 | 150000 |
How can I write chart expression? If there are different amounts within the same Time Period then the sum would display. But looking for when amount is same.
Thanks.
Thanks. Basically 150000 is the total for both coverages. But we only have an overall figure. But if the user chooses Coverage A then 150000 should display and same if they choose Coverage B. In this case the total amount does apply to each coverage.