SALES ANALYSIS REPORT -Inventory dispay-

(0) Share

Report

Posted on by Community Member

Hey guys!

I try to display in the sales analysis report the inventory quantity of an item that it is shown in the item card, I just dont seem to get the right setup for the columm, I have played around with the "analysis type code" and "value type" but without much succes. You guys know the right set-up or you have any idea, perhaps by combining the output of two difference columms through a formula ?

Thanks in advance!

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Ahmed Mohamed Rafik 3,049 User Group Leader on at

Like (0)

Report

Hi Pollux1986,

Try Use Sales Analysis by dimension, it will achieve your requirement easily.

When you edit the report, their are 2 important fields you have to consider, and they are as follows:

* "Show as Columns", select from the drop-down list "Item".
* "Show Value As", select from the drop-down list "Quantity".

Then press (Show Matrix) and it will populate your data of items with quantity.

If you find this solution helpful, you can mark this answer as verified answer.

Thanks

Was this reply helpful? Yes No