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

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
AI Builder prioritize seasonal sales using ai

Prioritize seasonal sales using AI

Posted on January 22, 2025January 21, 2025

In the past, I wrote about the UEFA Euro soccer championship and used the AI Builder prediction model to predict how well the Dutch team would perform (URL to post). That made me wonder if I could find a use case to apply a custom prediction model to one of…

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

  • Agents
  • AI Builder
  • AI Prompting
  • Artificial Intelligence
  • Copilot
  • Copilot Studio
  • 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

  • May 2026
  • March 2026
  • February 2026
  • January 2026
  • December 2025
  • November 2025
  • 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