Expression Question

[sterno14]

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.

[dplr-rn]

Dont think theres an easy way to do in expression
it maybe better to do it in script.
Are you saying coverage is not related to amount at all?

[sterno14]

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. 

[dplr-rn]

i dont understand your full picture but try something like below
dont load amount into the main table. create another table which has the amounts by timeperiod

load distinct TimePeriod,Amount from source;