I dunno why, but some of the time I cannot wrap my head around pivot tables. Here is what I want to do and here is how my data is structured and the column headers….
Account | A Prime_TV Revenue | B Prime_TV Revenue | A Premium_TV Revenue | B Premium_TV Revenue
Pivot table I want…
TV Category | Company A. | Company B
Prime_TV. | $500000 |. $6000000
Premium_tv. |. $55000. |. $5000
Is this possible given the data structure that i have?