Pivot Mode | Analyze Worksheet in Business Central
- 4 months ago
Agenda of the Video▶️: To show, List Page filtered Data in Pivot-Table-Mode.
Here, Worksheet = Page Data (List Page/Vouchers/Journals).
-------------------------------------------------------------------------------------
Create "Pivot Table" to *Analyze* Worksheet Data | Version: 23.2 (INDIA, Business Central).
-------------------------------------------------------------------------------------
Benefit of the▪️Analyze▪️Option❓
▫️When you create Pivot Tables in Business Central using the Analysis mode feature.
▫️This feature allows you to interact with data on list pages, and analyze it directly in the client without having to open the page in Excel, or Run a Report.
--------------------------------------------------------------------
✍️Steps are as follows: -
✅1. To create a Pivot Table, you can switch to Analysis Mode by adding multiple tabs that represent different tasks or views on the data.
✅2. Once you’re ready to Analyze data on a list page, simply turn on the Pivot Mode toggle switch and drag fields that are to be summed to the Values part.
✅3. Once you’re ready to Analyze data on a list page, simply turn on the Pivot Mode toggle switch and drag fields that are to be summed to the Values part.
✅4. You can define groups that show up in the column part of the data area by dragging fields to the Column Labels part of the Columns menu.
✅5. Column Grouping works best if the grouping field only contains a few values.
You can also apply more filters to the dataset using the Additional Filters menu of the field modifier area.
--------------------------------------------------------------------------------------------
▶️Video ContentCreator | Editor | Publisher | Speaker: Madhavi Pandey.
----------------------------------------------
This platform has been designed to provide easy solutions via Freelancing on those issues which are related with Dynamics ERPs.
It also includes Vlogging, Discussion on Concept based Scenarios, Online/On-Remote Short Solution for Pre & Post implementation of ERP Software. We are providing Support Services & Suggestion after Post-Implementation (on pre-payment basis).
_____________________________________
Freelancing Website: ➡️www.NavisionFunctionalExpert.com
_____________________________________
We are publishing Short-Blogs on our Freelancing Website.
To Read the Blog related with Navision & Business Central, visit the Website's Short-Blog Section.
https://navisionfunctionalexpert.com/short-blog
---------------------------------------------
Follow us on LinkedIn | Dailymotion | Instagram | Twitter | Facebook | Soundcloud
Here, Worksheet = Page Data (List Page/Vouchers/Journals).
-------------------------------------------------------------------------------------
Create "Pivot Table" to *Analyze* Worksheet Data | Version: 23.2 (INDIA, Business Central).
-------------------------------------------------------------------------------------
Benefit of the▪️Analyze▪️Option❓
▫️When you create Pivot Tables in Business Central using the Analysis mode feature.
▫️This feature allows you to interact with data on list pages, and analyze it directly in the client without having to open the page in Excel, or Run a Report.
--------------------------------------------------------------------
✍️Steps are as follows: -
✅1. To create a Pivot Table, you can switch to Analysis Mode by adding multiple tabs that represent different tasks or views on the data.
✅2. Once you’re ready to Analyze data on a list page, simply turn on the Pivot Mode toggle switch and drag fields that are to be summed to the Values part.
✅3. Once you’re ready to Analyze data on a list page, simply turn on the Pivot Mode toggle switch and drag fields that are to be summed to the Values part.
✅4. You can define groups that show up in the column part of the data area by dragging fields to the Column Labels part of the Columns menu.
✅5. Column Grouping works best if the grouping field only contains a few values.
You can also apply more filters to the dataset using the Additional Filters menu of the field modifier area.
--------------------------------------------------------------------------------------------
▶️Video ContentCreator | Editor | Publisher | Speaker: Madhavi Pandey.
----------------------------------------------
This platform has been designed to provide easy solutions via Freelancing on those issues which are related with Dynamics ERPs.
It also includes Vlogging, Discussion on Concept based Scenarios, Online/On-Remote Short Solution for Pre & Post implementation of ERP Software. We are providing Support Services & Suggestion after Post-Implementation (on pre-payment basis).
_____________________________________
Freelancing Website: ➡️www.NavisionFunctionalExpert.com
_____________________________________
We are publishing Short-Blogs on our Freelancing Website.
To Read the Blog related with Navision & Business Central, visit the Website's Short-Blog Section.
https://navisionfunctionalexpert.com/short-blog
---------------------------------------------
Follow us on LinkedIn | Dailymotion | Instagram | Twitter | Facebook | Soundcloud