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

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

Like (0) Share

Report

Posted on 26 Oct 2021 06:44:29 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

All responses (2)

Answers (0)

Suggested answer

CRMJetty 3,508 on 29 Oct 2021 at 04:41:10

Like (0)

Report

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

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
Suggested answer

Community Member on 26 Oct 2021 at 08:29:28

Like (0)

Report

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

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.