How to Find Repeated Values or Characters in Pivot Table

[khasimvali85]

Hi Community,

     Can you give the formule for how to find Repeated value in Pivot Table

I Have the data given below       

                    CallNO                                                         CallCount                           RepeatedNo

-------------------------------------------                      ---------------------------------------       ----------------------------         

hyd1234,hyd1234,hyd1234,hyd3456,                            3,1                                    hyd1234

del1234,del8763,del8763,del8763,del8763                    1,4                                   del8763

Can anybody give the formule for this?

Regards,

Khasim

[khasimvali85]

Hi Tresesco,

               There is no other option to show pertecular value shown in colour?

Regards,

Khasim.