[esmeraldaw]

Fellow NS users,

I currently have a report that shows a matrix with sales per item as follows:

item1 … item2 … item3

date1

date2

date3

Instead of by date, i would like to report by period.

For example, for the sales of item1:

jan-1 2

jan-2 5

jan-3 1

feb-1 4

feb-2 1

the reports should show

jan 8

feb 5

Does anyone know how to get this done?

Esmeralda
This is a cached copy. Click here to see the original post.

[WalterM]

You might need to do this by search (do you have Pivot Tables turned on?)

Create an item search.

Have several amount fields(pulled from transaction fields) and leverage a CASE statement in each amount field to reflect the date in question.

You may need to go at this from a transaction search…

If you have Pivots turned on, viewing this matrix report in the fashion you suggest.

In the search, items would be vertical and weekly amounts would be across the top.

Good Luck!

[Author]

Posts