Blog - Page 2 of 15

OLAP Tools in Pivot Table

MS-EXCEL-91-OLAP Tools in Pivot Table - Offline OLAP - Convert to Formulas - MDX Calculated - Excel

OLAP Tools menu in PivotTable. “Offline OLAP…” option, this feature allows you to work with data from an Online Analytical Processing (OLAP) cube even when you are disconnected from the server

Create Set Based on Column Items or Row Items

MS-EXCEL-90-Create Set Based on Column Items - Create Set Based on Row Items - Pivot Table - Excel

“Create Set Based on Column Items” groups specific items from a column together for easier analysis.

Solve Order in Pivot Table

MS-EXCEL-89-Solve Order in Pivot Table - Solve Order Problem in Calculated Item - List Formula

In the context of a Pivot Table, the “solve order” refers to the sequence in which Excel resolves conflicting data or calculations.

Modify or Delete Calculated Field-Item

MS-EXCEL-88-Modify or Delete Calculated Field in Pivot Table - Modify or Delete Calculated Item

Modify or Delete Calculated Field in Pivot Table | Modify or Delete Calculated Item in Pivot Table

Use of Calculated Item in Pivot Table

MS-EXCEL-87-Use of Calculated Item in Pivot Table - Calculated Item in PivotTable with Example

Unlock the full potential of Pivot Tables with our latest tutorial on Calculated Items

Calculated Field in Pivot Table

MS-EXCEL-86-How to Use Calculated Field in Pivot Table - Calculated Field in PivotTable with Example

Discover the power of Calculated Fields in Pivot Tables and unlock advanced data analysis capabilities. Learn step-by-step how to create and utilize Calculated Fields to perform custom calculations, derive insights, and enhance your data visualization in Pivot Tables.

Clear, Select, and Move Pivot Table

MS-EXCEL-85-How to Move Pivot Table to another sheet - Clear, Select and Move Pivot Table - Hindi

Move Pivot Table to another sheet | Clear, Select and Move Pivot Table | Hindi

External Data Source in Pivot Table

MS-EXCEL-84-Use of External Data Source in Pivot Table - Change Data Source - Connection Properties

How to Refresh Pivot Table? How to Change Data Source in Pivot Table? What are the Connection Properties in the Pivot Table? How to create pivot table from an external data source?