Skip to Content
0
Former Member
Mar 13, 2015 at 06:45 PM

Grouping Question

14 Views

My data looks like this.


Fruit, Apple, Fuji, 1, 1
Vegetable, Potato, Russett, 2, 2
Fruit, Apple, Red, 1, 3
Fruit, Apple, Granny, 1, 2
Vegetable, Potato, White, 2, 1



This data is not sorted beforehand.



I have every field in a group (say Group1, Group2, 3, 4, and 5). I would like for the data to read like this.



I've creates a group combining the fields 4 and 5 using a formula.



The problem is when I drop my cross tab into Group 5 it keeps
repeating the column header. Whereas, if I drop into Group 4 it does
not repeat the column header. However, it does not sort on Field 5.



I would think there is some easy way around this.



TIA.