1. Engineering
  2. Computer Science
  3. please create a pivot table using the data below to...

Question: please create a pivot table using the data below to...

Question details

Please create a Pivot Table using the data below to find the total number of weeks each artist maintained a #1 album. Input the answers in the yellow highlighted area. Place the pivot table on B13 of this tab.

Can I have the Excel formula? how to get it?

Artist Weeks at #1 Week of Album Artist
Phil Collins 1/6/1990 ...But Seriously Phil Collins
Milli Vanilli 1/13/1990 Girl You Know It's True Milli Vanilli
Paula Abdul 1/20/1990 ...But Seriously Phil Collins
The Beatles 1/27/1990 ...But Seriously Phil Collins
Beastie Boys 2/3/1990 Forever Your Girl Paula Abdul
2/10/1990 Forever Your Girl Paula Abdul
2/17/1990 Forever Your Girl Paula Abdul
2/24/1990 Forever Your Girl Paula Abdul
3/3/1990 Forever Your Girl Paula Abdul
3/10/1990 Forever Your Girl Paula Abdul
3/17/1990 Forever Your Girl Paula Abdul
Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution