Service | Customer Service, Contact Center, Fie...

How can I show the Total of a Column in d365 CRM

(0) Share

Report

Posted on by James_Oliver

186

I have a view in which there are columns eg. Name, Id, Amount

I have 30 record in that view, I have to show the total of a column (Amount)

I have to see what is the total amount of that particular column. How can I do that

Anyone ?

Thanks In Advance

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

Hi Daniyal3165,

Based on your description, you want to be able to show the total of amount for all records of the view not sub-grid, which is impossible.

But you could create a chart to show this, since you can show charts beside a view at any point.

Details:

The key is the field show in Horizontal ( Category ) Axis Labels, you must ensure the field value is empty in all records(You can create a new field and not add it to any forms/views), Otherwise the total amount of all records is not available.

Or you can export current view to excel and sum the amount column in the excel.

Was this reply helpful? Yes No
Suggested answer

CRMJetty 3,512 on at

Like (0)

Report

Hello Daniyal3165,

Please refer this article,

https://nishantrana.me/2020/05/27/different-ways-of-getting-record-count-total-in-dynamics-365/

I hope it helps,

Thanks.

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365

Was this reply helpful? Yes No