150
I am having a difficult time find a report that will allow me to choose a date period for a month and show me the sales with my COGS to see the margin either by business unit, grouping or some category. Any help would be appreciated.
Customer / Item Sales - show sales amount, and profit for each sold item to each Customer.
Try creating "Inventory Analysis Report" - it is similar to Inge's mentioned Financial Reporting, where You define Rows and Columns - You can create needed rows and then provide the filter how values are calculated - it can be Item or Item Group with a filter to global dimension. In columns You can set to show value beginning balance Balance at end date, net change, year to date and others and for this period show Quantity, Sales Amount, Cost amount, Unit Price, Unit cost and others.
I think you have to create you own report for that using Financial reporting - what used to be called account schedule.
Maybe you can find some inspiration here:
learn.microsoft.com/.../bi-how-create-analysis-views-reports
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (