Grouping the records in pivot table

[sijojoseph22]

Hi All,

We are having 15 records in the attached qvw.

We need to make the  as per the screen shot. We need this to generate a report in Nprinting.
1-5 records as value 'First Five'
  6-10 records as value 'Second Five'
11-15 records as value 'Third Five'

Thanks,

Sijo

[rubenmarin · Accepted solution]

Hi Sijo, you can use this expression:

=If(RowNo(TOTAL)<=5, 'First five',

  If(RowNo(TOTAL)<=10, 'Second five',

   If(RowNo(TOTAL)<=15, 'Third five')))

[maximiliano_vel]

Your records should be in order.

See attached file