Urgent need Calculations for given Table?

[khasimvali85]

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

[MK_QSL]

Kindly provide sample data...