i have a requirement (see attached) to create a pivot grid... that looks like a grid with only the last 2 fields as a pivot... we dont want a drill down.
is this possible...or do i have to concatenate order item qty size into one field...
or do i have to come up with some type of sql pivot ...i am at a loss but its a hard requirement for the project i am working on...
order item qty size ...... date 1 date 2 date 3
is this possible...or do i have to concatenate order item qty size into one field...
or do i have to come up with some type of sql pivot ...i am at a loss but its a hard requirement for the project i am working on...
order item qty size ...... date 1 date 2 date 3
Comment