exceltoxl.com

Hi there,

This complete week, we will learn about few inner techniques of Pivot Table. These are few of my learnings in near days so thought of sharing to power your skills on Pivot. In my previous post, I spoke about How Human Parts Resembles Excel Features where Pivot is compared with Kidney. So, we will do some cleansing to our Kidney. :)

In this week we will learn about:

1. Adding few points to a Simple Pivot Table

2. Grouping data from months and years

3. Grouping data for words

4. About GETPIVOTDATA and its Advantages

5. How to avoid displaying the removed items in the pivot table

...

CHALLENGE FOR TODAY:

To group data for words or for example say we have an existing sales team and planning to hire a new sales team. After a month if we need to compare the values between old sales team and new sales team for which the data to be segregated, here is a challenge to group the particular REP's for old sales team and the one who are in new sales team. How do we group the teams in the pivot table is our challenge for today?

GROUP DATA BY WORDS:

• Select the rep names in the pivot table who falls in old sales team and go to ANALYZE in PIVOTTABLE TOOLS.
   
• Click on Group Selection in GROUP 
   
• Now, the names are grouped and by default the group is named as Group1
   
• Select the Group1 and GoTo Formula Bar and change it to "Old Sales Team"
   
• Similarly select the names for Group 2 and change the Group name to "New Sales Team"
   

Now, we can now see the grouping for rep's.

That's it! Magic works!!!

DO YOU USE PIVOT?

Have you learnt something out of these episodes? Want to share anything with us. Use this space and post your valuable ideas or suggestions using the below comments section.

If you like this post, please do share it on your social networking sites just by one click on the icons placed around the blog.

If you want to support me for maintaining this blog, please do REGISTER here for free. 

Thanks,