Small and medium business | Business Central, N...

Sales analysis report, total sales by Salespeople

(3) Share

Report

Posted on by Frida_Admotion

387

Hi! I am still struggeling with the sales analysis report. In the analysis line template, i would like to have one line for each salesperson, to show the total sales on all their customers. I tried to set the type-column to Salespeople, but the Intervall-column just want me to choose a dimension.

What is the proper way to do this?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Khushbu Rajvi. 22,792 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

If it provide some hint: https://www.dynamicsuser.net/t/sales-by-salesperson-customer-item-report/20889

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 101,995 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi, In 25.1, Microsoft released the new Sales by Salesperson (Power BI Report), you can try it first.

https://learn.microsoft.com/en-us/dynamics365/business-central/sales-powerbi-sales-by-salesperson?wt.mc_id=DX-MVP-5004336

Thanks

ZHU

Was this reply helpful? Yes No
Suggested answer

Shauna Langley 903 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi,

I got this to work as follows:

Sales Analysis Line Template defined as below.

I had a sales analysis view setup as follows

The Sales & Receivables Setup must have the salesperson dimension entered.

The matrix should then show your values.

Hope that helps,

Shauna

Was this reply helpful? Yes No