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