Hi,
I have Table like
Calls:
Load ComplaintDate,
ComplaintNo,
CallsCOunt,
BelongsTo,
Branch,
Franchisee,
CloseDate,
CallPending Reason
From D:................Calls.qvd(qvd);
and i want to display out put table like give below
Need These are all Calculations in Pivot Table
Calls Complaint No/Call No No of Calls >=3 Become Red ComplaintNo Show
5 Hyd1,Hyd2,Hyd3,Hyd4 1,1,1,2 Hyd4
4 Mum1,Mum2 2,2 Mum1,Mum2
3 Beng1 3 Beng1
2 Del1 2 Del1
10 Gur1,Gur2 5,5 Gur1,Gur2
