Ungrouping data in a crosstab 1

[dannyb29]

Hi All,

When creating a crosstab, is there any way of ignoring the grouping so that each record albeit the same information appears on every line?

For example
Date User Product #QTY Sold
10/10 1541 1000 1
10/10 1541 1000 2
10/10 1541 1010 1


Many Thanks
Dannyb

 

[lbass]

The data you show does not appear to require a crosstab. Why are you pursuing that approach?

-LB

 

[dannyb29]

Good question....Not sure why I was doing it this way. Thank you for making me see the light. Ive sorted it!

Dannyb