Hospitality Business Analytics Pivot Tables

I need you to make pivot tables that find out a data sets:   

KPI,

Occupancy

ADR

RevPar

FInish the tabs:
Market Structure by room Scale,

current statistics,

and Pipelines by chaines (Create custom pivot table for this one that is similar to whats displayed for Current statistics and Marketstructure by room scale)