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

AI Prompting AI Insight Cards for tables

Using AI record summary for tables

Posted on January 28, 2025January 27, 2025

One of the things that was just released in Public Preview is the AI record summary for tables (link to release plan). The cool thing about this feature is that it allows you to create your own custom AI Prompt, which will then be used to display the Copilot summary…

Read More
AI Builder AI Builder language models

Leverage AI Builder language models to collaborate more easily

Posted on October 2, 2024October 2, 2024

Within the AI Builder, there is a whole range of prebuilt models that you can use within for example the Power Platform. In this blog post, I would like to focus on two AI Builder language models that are prebuilt and available to you: Use case: Padel Vamos goes internationally…

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

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

  • June 2026
  • 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