This content has been marked as final. Show 3 replies
I have a data policyno, claimno, prem, claimamt.
I want create a chart with policyno wise claimamt. claimamt should be caluculated by claimno and then sum to policyno wise base on the logic given.
If ClaimAmt of each claim is greater than 100000 then 100000 else ClaimAmt.
If ClaimsAmt of each claim is greater that 100000 then ClaimAmt - 100000 else zero.
Please let me know how to calculate Post & Pre column.
The output should be like Output table. Only policy dimension to be used.
Please see the qvw file attached for your reference.