Showing Pivot Table Data

[APElliott]

Hello,

I've just started using Pivot Tables for the first time and I'm sure I'm on the brink of saving a lot of time, but I just can manage to do something.

What I have is a worksheet:

Column A is Page Refs ie 02/01, 02/02, 02/03 etc
Column B is Item Refs ie A, B, C, D and so on
Column C is Descriptions, all Desc have a page ref, but not all have an item ref
Column U then has a Subcontractor Ref ie 03, 04, 05 etc, but reference only appear where there is a Page & Item Ref

OK When I go to my pivot table and ask it to show only Sub Ref 03. It does exactly that.

What I would really like it to do is if Sub Ref 03 appears on a row that was page ref 02/47 item ref B, I would like it to show all other items with the same page ref.

Is this possible?

Thanks

Andrew

 

[fkegley]

Have you tried using multiple Page fields in the Pivot table? As an alternative, you could possibly do it with the AutoFilter command.

Frank kegley
fkegley@hotmail.com

 

[APElliott]

Cheers Frank,

I've tried multiple Page field but it does exactly what you expect it to, unfortunately I want something slightly different!

I'd be interested in your AutoFilter command.

Thanks,

Andrew

 

[APElliott]

Cheers Frank,

I've tried multiple Page fields, but it does exactly what you expect it to, unfortunately I want something slightly different!

I'd be interested in your AutoFilter command.

Thanks,

Andrew

 

[SkipVought]

Hi Drew,

1. Turn on the AutoFilter (Data/AutoFilter)

2. Select the desired Sub from the AutoFilter Dropdown

3. Copy the Text Value -- NOT the cell.

4. Data/Autofilter/Show All

5. Select the Page Ref Dropdown - Custom

6. Paste value (Equals YourValue) and enter

If you want to automate 3-6, let me know.



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[APElliott]

Cheers Skip,

I'm getting a bit stuck on what you want me to copy and where you want me to paste it ie 3 and 6.

If you could Automate this I'd be over the moon.

PS I'm new to AutoFilter and Pivot Tables so go easy!

Thanks,

Andrew

 

[SkipVought]

You know the difference between then text in a cell and the cell.

If you select a cell and copy, you have copied the cell (including all the attributes of that cell)

If you select a cell and F2 (Edit) and copy the TEXT in the cell, then you ONLY have the text.

With the text copied, you select the autofilter drop down for the column containing that text value and in the drop down there is a selection named Custom. A Custom Auto Filter window is opened with a place to enter 2 criteria. Paste the value in the right-hand textbox and select the appropriate filtering operator like Equals. Hit OK and ovserve the results.

When you'r comfortable with the procedure, try macro recording it and see what you get. It will have to be modified, so post the code and we'll go from there.


Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com