$1)$ You will need to create one or two calculated fields $($created data$).2)$ You will create more than one $($and possibly many$)$ pivot table for this case. It will all de $3)$ Your analysis should include: $($a$)$ Identification of Trevor's best customers in terms of bo worst customers in terms of both VOLUME and REVENUE; $($c$)$ identification of the mechani productive in terms of both VOLUME and REVENUE; $($d$)$ Identification of the type of work t $4)$ Please place each of your pivot tables on a separate tab within the Excel file and name