![]() ![]() From the Show Values As tab, we select % of Grand Total. We insert the amount field into the values area again, by dragging-and-dropping it, and then open the Value Field Settings dialog. ![]() Now, let’s tackle the percent of total column. We use region and rep as the row fields, and amount as the value field. To create the PivotTable report, we begin by setting up the row and value fields. Let’s take a moment and look at the data source for the PivotTable: Sound good? Alright, let’s do this thing. When we are done, we want the report to look a little something like this: We also want to show each rep’s sales as a percentage of the company total and as a percentage of their region’s total. We want to summarize our data by region, and within each region, by rep. Overviewīefore we begin, let’s review our objective. This post demonstrates how to set up a PivotTable to show 100% on the subtotal lines when using the show values as a percentage of parent total option. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |