Report Sales Statistics grouped by Item Category

tompynation

Hi,

is there any report inside NAV 5.0 SP1, which shows the Sales Statistics of the Items grouped by the Item Category Code?

But this should run for each Sales Person.

So for each Sales Person i want to see what he sold, and what he sold should be splitted by the Item Category Code

tompynation

If it doesnt exist, From which table can i calculate how much the Sales Person has sold?

i4tost

You create 2 dimensions and use them in all sales transactions. One should be SALESPERSON and other is ITEMCATEGORY. Then use Analysis by Dimensions within Sales module to see sales statistic. This is only for future transactions because you do not have this in historical data.
Hope this helps.