14 Replies Latest reply: Apr 7, 2014 7:09 AM by Yepuri Murali Krishna RSS

    Alternative marking of group of rows?

    Vidit Saxena

      Hi I have the following pivot table.

      In which i want to differentiate each group of rows, may be by changing the background color of each set of rows alternatively.

      Project NumberProject NameYear - MonthResBudSchQua
      E-2012-007A2012-081111
      2012-091111
      2012-101111
      2012-111111
      2012-121111
      2013-011111
      2013-023332
      2013-033332
      2013-043332
      E-N-2013-002B2012-101111
      2012-111111
      2012-121111
      2013-011111
      2013-021111
      2013-031111
      2013-041111
      G-2012-015C2012-082223
      2012-092233
      2012-102232
      2012-112222
      2012-122222
      2013-012322
      2013-022322
      2013-032222

       

      Desired O/p:

       

      table.JPG

      Can Any one suggest a solution?

       

       

      Leo