Creating a Pivot Table from a complex Excel sheet, how do I get this to work?

[ktec27]

Hello!

I am attempting to create a Pivot Table from a complex Excel sheet. Below is an example of 1 item I am tracking.... this is 1 of 70, and they usually have 20 or so "Social Insertions".

The goal of the Pivot Table/Chart is to have an easy to digest overview of the month and of the quarter. Any advice on how I can do this in Excel?

Thank you in advance!

Asset	Description	Web / Social / Video Channel	Date Published	bit.ly	Social Insertion	Date	Reach #1	Impressions #1	Clicks #1	Pageviews
Editorials
Sneak Peek Video Release	Sneak Peek: Architecture & Bar	NETWORK	Website	3/30/2016	http://bit.ly/23g1btYa						21
			Twitter		@Accountname	3/31/2016 20:55:00	49	93	0
			Twitter		@Accountname	3/31/2016 20:22:00	575	121
			Twitter		@Accountname	3/31/2016 17:15:00	92,340	1,332
			Twitter		@Accountname	3/31/2016 12:30:00	37,480	841
			Facebook		n/a
							4	2,387	0	0	21

<colgroup><col style="width: 177px"><col width="253"><col width="100"><col width="85"><col width="122"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"></colgroup><tbody>
</tbody>

 

[Meggesto]

If you're currently keeping track of all of this information in Excel then there's certainly a way to present it in a condensed version for monthly or quarterly review. To help I'd need a bit more information from you. How are each of the 70 events you track cataloged; are they 70 worksheets in a single workbook, is there just one worksheet in one workbook or in 70 workbooks? Are there structured template designs for each event that already quantify some of this information; or is there sorting and organizing that needs to be done per each event first at the close of the month/quarter before the data can be quantified. What information needs to be seen on the monthly/quarterly report? Screenshots and data samples would help here to give you direction as to what could be the best approach.