excel for mac tabluar vs form pivot table

Apart from the mathematical operations, Pivot table got one of the best feature i.e.

Lets drag the Flat nos field into Filters and we can see the filter for Flat nos would have been created.

But we can actually create it and which helps us in various decision-making purposes.

Similarly, we can do sorting from smallest to largest, sorting by color and even we can perform number filters like, and many more.

This plays a major role in decision making in any organization.

Now lets look at the way we display the list in different ways.

Select the data then go to insert tab and select a pivot table option and create a pivot table.

It is simple as we just select any cell inside the pivot table and well go to analyze tab on the ribbon and choose insert slicer.

By this, we can easily filter out multiple items and can see the result varying in value areas.

From the below example it is clear that we had selected the functions that are visible in the slicer and can find out the count of age category for different Industries (which are row labels that we had dragged into the row label field) which are associated with those function that is in a slicer.

We can change the function as per our requirement and can observe the results vary as per the items selected.

If we right-click anywhere on the slicer to report connections.

We still need the tables that we used earlier and just use a formula to create this string of values and separate them with commas.

Just select the cell and go up to analyze options tab, click on field headers that will hide the cell.

Now if we make changes in the pivot table filter it reflects in all the methods.

But eventually for comma separated solution slicer the list is required.

For Ex: If we have got a huge list and there are blanks too then in order to select blank we can easily get selected by searching for blank in search box rather than scrolling down till the end.

For Ex: If we want to select any product with certain currency like rupee or dollar etc then we can use label filter doest not contain and should give the condition.

CFA And Chartered Financial Analyst Are Registered Trademarks Owned By CFA Institute.

By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy.

Excel For Mac Tabluar Vs Form Pivot Table