Now that we know how to create a Pivot table, Let us look into few advanced aspects of it. Let us find out the Total Sales Amount for the Sales data done by each region in terms of percentage of Total Amount. Looking at the data, it is clear that we don’t have a…
What is Pivot Table in MS Excel? Ever wondered what we would do when we have chunks of data with thousands of rows and columns to be processed? Finding a minute amount of information from the data would be a hefty and time consuming task, right? Well, Understanding the data itself consumes a lot of…
