sales displayed by day 1

[pamgdevlin]

Help please....

I have to create a report that shows sales grouped by product size, by day, in the current month, displayed horizontally on the page...for example

product size 9/1 9/2 9/3 9/4
size 10 3 5 7 9
size 12 2 4 6 8

Can someone give me an idea of what the formula I would use to get this to happen.

Thanks in advance for all your help

pamgdevlin

 

[lbass]

Insert a crosstab with {table.date} as your column, size as your row, and sum of sales as your summary.

-LB

 

[pamgdevlin]

lbass,

Thanks.....I was over-thinking this and making it much more difficult than it actually was!

Worked perfectly!