Sum

[upaliwije]

Hi,

In my QV Docuemnt I have following data

POLICY_NO	CLAIM_NO	Risk(Nos)
CO30151B0003813	CLCO301B16000002	21
CO30151B0003813	-	22
Total		43

I want to show max Risk(nos) in the total row of my pivot table . But I get 43 as shown above my expression is

sum(DISTINCT RISK).

Pls help me to correct it

[Anil_Babu_Samineni]

Instead of "43" what are you expecting to see? May be 22

Or this

[upaliwije]

yes 22 How Can I write the expression

[Anil_Babu_Samineni · Accepted solution]

Simple write

Max([Risk(Nos)])

Or

Aggr(Max([Risk(Nos)]),POLICY_NO)