How to add a field to a pivot table more than once

Lets take a look.

Lets start off by adding Product as a Row Label.

Then lets add Total Sales as a Value.

As usual, we get the sum of Total Sales.

We can even add the same field again, and set the math function to Average.

Lets remove the second and third instances of Total Sales and build a percent of Total View.

Now we have Total Sales displayed as both a sum and a percentage.

As before, we can rename this field to something shorter and more meaningful.

And if we add it again to Row Labels, its moved back.