Questions Raw Data Pivot Table 1 Pivot Table 2 Pivot Table 3 Pivot Table 4 Email INCODE BRAND REV HOTELST HOTEL PHONE UIT ALE ACME incode A ACW A AR HON EX GA GA OH ARWW ON TRA TANGA 250 GR GR GA 14 2014 42 000 ene am 112 AMR GA TO TTO - EX HEXS AND 2000 AT NO 24 02 13 13 CA AROC ARBE HO ARCH ARCH Care 241 350 GA DA DA ARER AIR ARCH 4 ARCH AN ENS TIP ATU 30 GA GA GA PA wa POINT 23.94 GA CON 43 000 A AT A ATL M ATL AT ATE ATE ATE ATL ATL ATL ATL ATL 04 210 re 3300 AU APUR ALTY ANTO APUR ATLO APUD ALLW ATLLW ALL ATUP AUSCO AUSCO AUSTR HE HEX HENS HOLI OL HERS HE 614 50 6500 G ON SA SEN SUS S 2 GAGA 530 GA 530 GA 23.GA 2. GA 6.57723 GA GA 53 GA GA 30 GA GA 30 GA CA BTX 2x WAT tx . STY 10114 1014 HO MER AT 313 30 00 AN 12 AUS NE AUST AUT EN EN PER 10 Tr DOL DOL M DRF REN PEN EN 14 TE 4 DA w HEN 10 10 4700 BIMAI VA CORO COUT CCYGA OP RES HE W 1 TX 1. AL IMGA 21.12. 334353 TX CA 2015 SC 122 OR TONGA 10240 be C CU CCY CH CLE CH C CA HEN HE COM CHOA GA OM OM HEN 20 OH GA TO LKW CM CUGA CHISO CS CSGP CHIN CM CW w HENS HE DOA 2200 W . MO IN VA W CSO HOLI GA 2000 31 2 HES IN 20 20 CTM CT CVO BEN OM 000 DA DARIDA DALT WA 0 TE DAL TOT GA 1410 ESCA CA HCPS PERS PERS RE TE SH DI DON DOW DON DOWE 010 SO OSO ATRON 2. TX 21.NO DW 200 TO DO DO TX GA GA FL 2650201OA 00 BOLO DAH DO DOLEX DOLOR DISON ENDO ER ORGA TY 00 42412 503 EMO HERS ON FOR GA MONY TO HEN 4 M GA GORA GRROS GSPOT TO DO GRE BSP GOP 512 GA 151733 MSC SC SC 16 1000 1000 200 710 30 200 200 ro OSP 71003300 402 1300 GIN NES HENS HES MES PEN CPR HEN HERS HER GIA GTX BIR ORTW HT 033 SC TX 15 SOO 10130441 TER OUT FO HOR H HINN HOU HOU sc MO UT 12.53. SOM 72515 10 OUTH UND TH HOL TEST TX TX HU HES KEN HES HEN 1 TK 19:2012 21,714 94 CAOW CA 10 500 How many hotels are located in Georgia (HOTEL STEGA) but the area code is not 770.404, 678, or 706? By using Pivot Table, provide the total revenue by state and by brand Questions Raw Data Pivot Table 1 Pivot Table 2 Pivot Table 3 Pivot Table 4 Email INCODE BRAND REV HOTELST HOTEL PHONE UIT ALE ACME incode A ACW A AR HON EX GA GA OH ARWW ON TRA TANGA 250 GR GR GA 14 2014 42 000 ene am 112 AMR GA TO TTO - EX HEXS AND 2000 AT NO 24 02 13 13 CA AROC ARBE HO ARCH ARCH Care 241 350 GA DA DA ARER AIR ARCH 4 ARCH AN ENS TIP ATU 30 GA GA GA PA wa POINT 23.94 GA CON 43 000 A AT A ATL M ATL AT ATE ATE ATE ATL ATL ATL ATL ATL 04 210 re 3300 AU APUR ALTY ANTO APUR ATLO APUD ALLW ATLLW ALL ATUP AUSCO AUSCO AUSTR HE HEX HENS HOLI OL HERS HE 614 50 6500 G ON SA SEN SUS S 2 GAGA 530 GA 530 GA 23.GA 2. GA 6.57723 GA GA 53 GA GA 30 GA GA 30 GA CA BTX 2x WAT tx . STY 10114 1014 HO MER AT 313 30 00 AN 12 AUS NE AUST AUT EN EN PER 10 Tr DOL DOL M DRF REN PEN EN 14 TE 4 DA w HEN 10 10 4700 BIMAI VA CORO COUT CCYGA OP RES HE W 1 TX 1. AL IMGA 21.12. 334353 TX CA 2015 SC 122 OR TONGA 10240 be C CU CCY CH CLE CH C CA HEN HE COM CHOA GA OM OM HEN 20 OH GA TO LKW CM CUGA CHISO CS CSGP CHIN CM CW w HENS HE DOA 2200 W . MO IN VA W CSO HOLI GA 2000 31 2 HES IN 20 20 CTM CT CVO BEN OM 000 DA DARIDA DALT WA 0 TE DAL TOT GA 1410 ESCA CA HCPS PERS PERS RE TE SH DI DON DOW DON DOWE 010 SO OSO ATRON 2. TX 21.NO DW 200 TO DO DO TX GA GA FL 2650201OA 00 BOLO DAH DO DOLEX DOLOR DISON ENDO ER ORGA TY 00 42412 503 EMO HERS ON FOR GA MONY TO HEN 4 M GA GORA GRROS GSPOT TO DO GRE BSP GOP 512 GA 151733 MSC SC SC 16 1000 1000 200 710 30 200 200 ro OSP 71003300 402 1300 GIN NES HENS HES MES PEN CPR HEN HERS HER GIA GTX BIR ORTW HT 033 SC TX 15 SOO 10130441 TER OUT FO HOR H HINN HOU HOU sc MO UT 12.53. SOM 72515 10 OUTH UND TH HOL TEST TX TX HU HES KEN HES HEN 1 TK 19:2012 21,714 94 CAOW CA 10 500 How many hotels are located in Georgia (HOTEL STEGA) but the area code is not 770.404, 678, or 706? By using Pivot Table, provide the total revenue by state and by brand