web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Sales Analysis Report

(1) ShareShare
ReportReport
Posted on by 392
Hi:
 
Is there not a way to create a report like this, using Sales Analysis Reports?
 
I have spent hours trying and cannot figure it out.
 
How in the world can you get a comparison of sales quantity, sales dollars, and gross profit comparison between this year and last year for a specific customer and item?
 
If this can't be done using Sales Analysis Reports, then can it be done in Business Central using some other means?
 
Thanks!
 
John
 
 
I have the same question (0)
  • Suggested answer
    Kamal Khakhkhar Profile Picture
    3,564 on at
    Hii There,
    as per your question i can suggest. you need to give your condition for connect the data items as per requirement.you can get the desired output by following 3 property.
     
    DataItemLinkReference
    DataItemLink
    DataItemTableView
     
    use this 3 . you can get the data as per requirement.
     
    Thank You.
    Kamal Khakhkhar
  • RH Profile Picture
    456 on at
    Hello, were you able to accomplish this?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 686 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 447 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 328 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans