16 Replies Latest reply: Sep 26, 2014 7:17 AM by Ashfaq Mohammed RSS

    How to split the values in separate columns of a pivot table?

    khasimvali shaik

      Hi,

           How to split the reminder call values in separate columns of a pivot table.

      Can anybody Explain with screen shots?

      Hi,

           Thanks for approaching I am attaching qvw file and Screen shot  below.

      In this table having ASC_ID, ReminderCOunt, ComplaintNo and ReminderCalls .

      In Reminder Calls i wanna Split each Column in ReminderCalls and to find Greater than 2 values should be Red Colour.

       

      I wanna add another column like greater than 2 calls = com[plaint no will show

       

       

      Ex:

      Calls;          Comp.No:

      1,1,2               1,1,99889989

      2,2,1               8855434,6434533,1

       

      in same application complaint no also available.