Pivot table filter required

Before I look at this properly, can you just confirm which version of Excel you are using? Your file is saved in 2003 format, your profile says 2007, but you talk about using slicers (which are only in 2010 onwards)...

Okay.

To use date as a pivot filter, you need to restructure your source data, so that Date is a single column. If you also want to filter on Week numbers, you'll have to add that as a separate column.

So your source data would look like:

	A	B	C	D	E	F	G	H	I
1	Profit Centre	Division	SOS Managed	Profit Centre Name	User Group	Business Unit	Date	Week	Value
2	1010001	CG	No	Profit Centre 1	80837-DEF	BU 5	01/07/2013	27	4
3	1010001	CG	No	Profit Centre 1	80837-DEF	BU 5	08/07/2013	28	9
4	1010001	CG	No	Profit Centre 1	80837-DEF	BU 5	15/07/2013	29	7

etc

Then you can add Date as a filter field in your pivot table (You could group by Year / Month / Day), and Week as another filter field.

I've transformed your data, and built an example pivot table. See attachment.

Just rereading your original requirement - yes, for top 10 and bottom 10, two pivot tables with slicers linked to both for the filter fields would be a good option. Shout out if you need help putting that together

You're welcome.

Sort of. I blogged about this a little while ago - see: http://excel.solutions/2014/03/unpivot-excel-data/

In your case, you have multiple dimension columns associated with each row. So to 'unpivot' your data, I inserted a column, and added an index number for each data row. I unpivoted, using the technique in my link above. Then reinserted your extra columns, and retrieved the initial values based on the index number. Took about 5 minutes to transform the data, another couple to build the sample pivot.

It's getting late on Friday evening now - but if you want a step by step guide to how to do this, let me know, and I'll put a guide together over the weekend Alternatively, if this is a one off exercise, feel free to ping me your actual dataset, and I'll transform it for you.

Maybe this will help you. I have re-arranged your data and produced a Pivot Table. The data in yellow is redundant and maybe not necessary in your main data.

Just to close the loop on this thread, here's a quick video tutorial on unpivotting crosstab data with multiple row fields.

https://www.youtube.com/watch?v=CqzvKifTdyI