Count Field

[upaliwije]

Hi Friends

I have attached my QV document with some claim data. My pivot table looks as follows

I want to add another coloum to this with Nos. That if int_month=Prv_mon I want add 1 my output table should look like below.pls help me to, accomplish this task

[tresesco]

PFA

[upaliwije]

Thanks for your reply, But here the total does not display for Nos

[Anil_Babu_Samineni · Accepted solution]

May be this for Nos

If(SUM(PROVISION)>0 and PRV_MON = INT_MON,1,'No Records Matching')

[Anil_Babu_Samineni]

This?

Sum(Aggr(If(SUM(PROVISION)>0 and PRV_MON = INT_MON,1), CLAIM_NO, INT_MON, PRV_MON))

[tresesco]

Just put sum() around the expression like:

Sum(If( PRV_MON=INT_MON,1))