I have a data set with some info - PK, Field1, Field2, Field3 etc.

I need to dynamically display columns base don Field1, with Field 2 and
Field 3 displaying once for each Field 1. The PK is the row. I figured
this out easily enough with column groupings.

My next step is to organize it in such a way that two of the values for
Field 1 require static positions (first column group and last column
group). Let's call these values "#1" and "#100". Now I can do this in
the stored proc, ordering it a certain way, but circumstance dictates
that I handle this on the front end.

Now I can add a filter to my column group for the Field 1 value to show
first. No problem. But I can't seem to figure out how to add a second
column group (exactly like the first) where I don't filter, then a
third column group (exactly like the first two) where I statically
filter on another value.

I guess in summary my problem is I can't figure out how to have the
same fields as column groupings multiple times. Is this possible?

Eg.
                     Field 1  ('#1")         Field 1  (dynamic, #2 -
#45, etc)         Field 1 ("#100"
         Field 2             Field 3           Field 2
Field 3          Field 2             Field 3
PK (row)

Thanks