Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

QUERY REPORT BUDGETED SALES VS ACTUAL SALES

Hi,

This is my first post on the forum:

I am trying to create a report to compare our actual sales (Quantity, Sales Value & GP) by sales person/ customer/ item group  versus budgeted data(set in UDT). My query is drawing the correct data on the first line of each sales person/ customer/ item group - actual and budget - but is then duplicating each line showing the correct actual data but nil budget data (we will not always have budgeted data against each actual sale and vice versa).How do I eliminate this duplication?

Many thanks

Jay

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question