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

[tresesco]

Use SubField() while loading to separate out the sub strings, like in attached sample.

[khasimvali85]

Hi tresesco,

                    Thanks for your replay I checked for your formule but it's not working i added one sample application.

Regards

Khasim.

[sushil353]

Hi,

if the below code help you..

for i=1 to 4

temp:

LOAD ID,

    Value,

    SubField(Value,',',$(i)) as test

FROM

t2.txt

(txt, utf8, embedded labels, delimiter is ',', msq);

NEXT i

t2 file is attached.

[tresesco · Accepted solution]

Try:

Concat(If(AGGR(SUM({<ReminderDate= >}ReminderCall),RemComplaintNo)>=3,RemComplaintNo), ';')

[khasimvali85]

Hi Tresesco,

                   Tresesco Its working fine now Thanks for giving help.

Regards,

Khasim.

[khasimvali85]

Hi Tresesco,

                        I need One more formule for the same application, i wanna display in ReminderCall field >3Calls Should be shown in Red Colour.

Regards

Khasim.

[tresesco]

[khasimvali85]

Hi Tresesco,

                    Thanks for Suggesting but this is not my exact output, i wanna display >3 ReminderCall fields should be shown in Red Colour.

Example:

>3 ReminderCall

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

1;1;1;1;1;1;12;2;2;2;3;3;3;4;4;4

above example i show only 3;3;3;4;4;4 should be in red Colour.

Regards,

Khasim.

[tresesco]

Unfortunately, color here works for entire cell, not for a part of cell.