2 Replies Latest reply: Aug 13, 2015 1:22 PM by kushal chawda RSS

    Pivot Table row format

      Hi All,

       

      In a normal Pivot table how do i color particular rows ( all rows greater than 800) and sort the rows in a order.

      Wanted to Highlight the rows 800 - 1000 and the dimension to be sorted as 0 -600,600 - 800 & 800 - 1000

      Attaching the QVW file for reference.

       

      Have got the anser for my question but in the grouping currently i am showing number of agents in each bucket instead of it i need to show no of instances means if one agent has touched 0 -600 bucket tow days in teh month it should show two instrad of showing 1 as Average