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
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
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,436
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
