Create four explicit calculated fields in Power Pivot and on the ReservationList table. Use the CALCULATE and SUM functions as necessary in your calculations. Calculate all Cash Net_Price in an explicit field named Cash_Profit in the PaymentType field column*. Using the AutoSum function on the Home tab and in the Calculations group, sum the Gross_Price, CC_Fee, and Net_Profit calculated columns. Accept the default names of the explicit fields. Format all of the explicit fields as Currency (using $ English).

*Hint: The filer should be ReservationList[PaymentType]=Cash

[RoomC