Monthly Report 1

[jsecco]

I am trying to create a monthly report that has the months as a column heading with the detailed information under each month. Is there an easy way to do this??

January February March .....
Item Code $$$$$$ $$$$$$$ $$$$$$$
Item Code 2 $$$$$$ $$$$$$$ $$$$$$$

 

[Smitty020]

I just made a report like that and this is what I did. I grouped by ItemCode and then made a formula called @Focus.

Focus = whatever your want, (ex revenue, sales totals, ect)

I set focus1 through focus 12 up like this:
if month(date) = month1 then {@focus} else 0

....and so on

then I summed the foci for each item code, for each month



It seemed to work nicely for me.

hope this is helpful,
Smitty020

 

[EagerBeaver]

Try working with Cross-tab reports. The only draw back is that you can only have one summary field. so you could do:

Month Month Month Month
Item 1 $$$ $$$ $$$ $$$
Item 2 $$$ $$$ $$$ $$$



KSK