'18. Other Aggregate Functions in Pivot Tables a. b. Use the - button to collapse the pivot table details back to the annual level (view the data grouped by year rather than quarter). Add Discount to Values. Calculate average discount (rather than sum) and change the format to percentage with one decimal. To do this, use Value Field Settings (accessed by double clicking or right clicking on the Sum of Discount header, or by opening the drop down menu for the Sum of Discount in the Values field selector). Add OrderID to Values and count how many line items are being grouped. Inside Value Field Settings, change the format to number with zero decimals. Inside Value Field Settings, change the format of Sum of LineItemTotal to currency with zero decimals