Chart Sum Values Help

[sterno14]

Hello All,

I hope this is an easy question, I will try to explain as best as possible.I have a chart, sample attached, which has two policy ID's  within the same date period. What I want is for all the Claim ID's to show the same value, which is the sum of the two premium values.Policy 1 has Premium = 100000 and Policy 2 has Premium = 200000. I want to do this in the chart expression.

Basically I have this:

What I want is this:

Any help is appreciated.

[vishsaggi]

May be this:

= Sum(TOTAL [Premium])

[sterno14]

Thanks for the quick reply. I probably should have included a larger sampling. The issue I have with Total is that if there are additional policy ID's for other dates then using Sum(TOTAL [Premium]) will show that value on all rows (Policy 3, Period 2017, Valuation Date 5/31/2017, premium 150000)?. I need to limit to the particular Period & Valuation Date

[vishsaggi]

Can you add some sample or update your qvw and give me your expected output?

[sterno14]

I updated the qvw. Here is what I want:

[vishsaggi · Accepted solution]

use this:

= Sum(Total <[Valuation Date] > [Premium])

[sterno14]

Thanks. That works. So that acts as group by essentially. Thanks for the help.

[vishsaggi]

Yes.