So in many states, a person could marry someone of the same gender and then get fired for being gay. Most states have no nondiscrimination protections for LGBT people, says David Stacy, government affairs director for the Human Rights Campaign, a national gay-rights group.
What is a pivot table? A: A pivot table is a reporting tool found in Microsoft Excel that allows a user to consolidate large data tables to extract information without using formulas. A pivot table is easy to modify, as it features a drag-and-drop interface that allows the user to view data sets in different ways.
The Average Function. The Average function in a pivot table works like the AVERAGE function on the worksheet to calculate the average (mean) of the values. It totals all the underlying values in the Values area, and divides by the number of values.hen you use the Average summary function, the results will probably show a strange mixture of decimal places, as shown in the pivot table at the left, in the screen shot below. Format the field to have a consistent number of decimal places (as in the pivot table at the right, above), so the numbers are easy to compare.