Refresh PivotTable Tools button Analyze tab AutoSave SC EX 8_ Bell&RodgersAccountingAnalysis.xlsx - Excel Ph otTable Tools Analyze File Home Insert Draw Page Layout Formulas Data Review View Help Design P Tll me what you want to do → Group Selection Ungroup Group Field Clear - Select - Move PivotTable Relationships Z Fields, Items, & Sets- P. OLAP Tools- PivotTable Name: Active Field: PivotTable1 2020 Average Rev Drill Refresh Change Data Source Drill Insert Insert Filter GOptions - F Field Settings Down Up- Slicer Timeline Connections PivotTable Active Field Group Filter Data. Data group Calculations C22 737102.449205013 A B D F G H source data changes reflected Bell & Rodgers Rever in PivotTable after refreshing 1 2 2020 and 2021 3 4 5 2020 Total Revenue 2021 Total Revenue 2020 Average Revenue 2021 Average Revenne $273,666 $355,800 $371,968 $309,242 $838,217 $429,778 $353,901 $456,957 $492,932 $592,821 $787,333 $536,788 $382,202 $386,540 $1,198,243 $778,731 $1,535,063 6. Auditing Forensics 7 0 to 5 YearS 8 0 to 5 YearS 9 O to 5 YearS $503,880 $655,118 $707,447 $568,680 $547,331 $711,599 $743,935 $251,940 $327,559 $353,724 $284,340 General 10 0 to 5 Years 11 0 to 5 Years Investment Тахes $618,484 $1,535,232 $3,970,357 S651,448 $841,693 S06,882 $1,092,119 total revenue changes $1,432,409 from 1,609,473 $4,924,551 $703,010 $710,885 $2,214,384 $1,474,364 $2,800,306 $1,676,433 $4,297,782 $707,801 $913,913 $767,616 $397,036 $325,724 $420,847 $453,441 $546,060 $716,205 $492,455 $351,505 $355,443 $1,107,192 $737,182 S1,400,153 12 0 to 5 Years Total 13 6 to 10 Years Auditing 14 6 to 10 Years Forensics 15 6 to 10 Years General 16 6 to 10 Years Investment 17 6 to 10 Years Тахes 18 6 to 10 Years Total $764,403 $73,079 $2,36,485 $1,557,461 $3,070,126 19 More than 10 Years 20 More than 10 Years Auditing Forensics 21 More than 10 Years General Investment average revenue changes from 804,737 22 More than 10 Years 23 More than 10 Years Таxes Revenue PivotTable Trendline Chart 6-Year Billable Hours Analysis Figures Ready Figure 8–54