Skip to content
JScheper.com
JScheper.com

BizApps, Powerplatform and AI

  • Home
  • Blog
  • Contact
JScheper.com

BizApps, Powerplatform and AI

enhanced grid options

Enhanced grid options to analyze data

Posted on September 4, 2024September 4, 2024 By Jeroen Scheper

With the Microsoft 2024 Wave 2 release there is another great feature available which allow sellers to have enhanced grid options. This allows you to analyze for example opportunities or quote data a lot quicker and more efficiently.

Move left Move right

This is one that is perhaps the simplest one but really useful to have, You now have the option to restructure your view by using Move Left and Move Right. This is one that will save quite a bit of time since you can now control this when having the view open.

Column width

Tired of finding where the line is between the two columns in the view to adjust the width? Now you can do this easily by selecting the column and then selecting Column Width. A popup will appear and you need to use the arrows to adjust the width.

Group By

The most impacting enhanced grid options will be the Group By function to group your data. Depending on the type of field you do have fewer or more options.

In the example below, where I have applied the Group By function on Lead Rating column you will see it does that straight away. Using the arrows you can see the actual data in the group.

When you do the Group By function on a date column like Lead Est. Close Date, you do have the option to decide how you want to group these, for example per week, month, or year.

In my example, I have grouped this by Month and in this grouping, it is also considering the year in this case.

Totals

The last one of the enhanced grid options that is now available will be the Totals. This allows you to quickly do an:

  • Average
  • Maximum
  • Minimum
  • Sum

In the example below I did show the Totals > Sum which you can see the result for at the bottom as you can see below.

enhanced grid options

One thing that is important to remember, even though you have Est. Revenue in your view and not Est. Revenue Base, therefore the sum is based on the global currency that is set up in your system.

Sales Model-driven Apps AverageColumn widthGroup ByMove left Move rightSumTotals

Post navigation

Previous post
Next post

Related Posts

Sales reopen a won quote

Reopen a won quote, as simple as that?

Posted on April 9, 2025April 8, 2025

On the opportunity record, this functionality has already existed for a long time, and I have had lots of requests from colleagues who were asking, “Can I reopen a won quote? ” because the customer came back to us, and now I need to make a few minor changes to…

Read More
Model-driven Apps updating data using Excel

Clever or not? Updating data using Excel

Posted on May 15, 2025May 14, 2025

One of the most popular tools that people use and find convenient is Microsoft Excel. I have been part of so many conversations where we had discussions about being able to export to Excel (or not). Updating data using Excel can be tricky, if you don’t use it for the…

Read More
Model-driven Apps create Word and Excel templates

Smooth UI or not? Create Word and Excel templates

Posted on February 26, 2025February 25, 2025

Microsoft has transformed the settings from the classic user-interface settings to a new way of managing the settings via the Power Platform Admin Setting app. This week I faced a setting where I believe unfortunately the classic interface has more advantages: create Word and Excel templates. Most people will remember…

Read More

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

ABOUT ME

  • LinkedIn
  • Mail
  • GitHub
  • YouTube
"BizApps and PowerPlatform dude with a passion for AI, sitting relaxt in his black shirt on a bounty white beach with palm trees, a azure blue ocean in the background and enjoying a good coffee "

~GenAI - DALL.E 3 and GPT 3.5

Subscribe

Please wait...

Thank you for subscribing!

Search

Categories

  • AI Builder
  • AI Prompting
  • Artificial Intelligence
  • Copilot
  • Customer Insights
  • Customer Service
  • Dataverse
  • Field Services
  • Generative AI
  • Model-driven Apps
  • Personal Development
  • Power Apps
  • Power Automate
  • Power BI
  • Power Platform
  • Reporting
  • Sales
  • SharePoint

Archive

  • October 2025
  • August 2025
  • July 2025
  • June 2025
  • May 2025
  • April 2025
  • March 2025
  • February 2025
  • January 2025
  • December 2024
  • November 2024
  • October 2024
  • September 2024
  • August 2024
  • July 2024
  • June 2024
  • May 2024
© 2024 - All rights reserved | Jeroen Scheper | Privacy Policy