Filtering which 'value' is reported on

[GreekyGreek]

Hi, I'm hoping theres a simple fix for this which I'm missing. I had a search and scroll through the board and couldn't seem to find this specific issue.

I have a pivot table reporting on several values and date ranges. The issue I have is that the table can become quite cumbersome and hard to read. I only really need to view one of these variables at any given point, I know I could make 3 seperate tables, but I already have tens of tables and would rather simplify it.

For clarity I've attached a screen shot of the Field List showing the values I want to be able to filter/splice on. I want my pivot to show me either Contracts, Volume or Revenue rather than all at oce.

I haven't attached a workbook as Im guessing its either an available function or not, rather than a technical fix. Hope this is okay.

If this is possible it would actually streamline a lot of my reporting so thought I'd drop a post.

[Pepe Le Mokko]

Hi and welcome
wouldn't slicers be what you need?

[GreekyGreek]

Thanks for coming back.

I've looked at that option, but unless I'm missing it a slicer only really works if you have a common variable within a range, such as 'salesperson' etc.

I essentially want to be able to dynamically amend my pivot to only have one of Contracts, Volume of Revenue in my Values.

[AliGW]

Instructions about how to attach your workbook can be found at the top of the page.

[GreekyGreek]

Example attached now.

[LJMetzger]

Hi GreekyGreek,

See the attached modified copy of your file that has the following options:
a. Contracts
b. Revenue
c. Volume
d. Contracts and Revenue
e. Contracts and Volume
f. Revenue and Volume
g. Contracts and Revenue and Volume

Code follows in Ordinary Code Module ModPivotTableSumValues. Change the Items in Red Below as required:

Please Login or Register  to view this content.

To enable Macros and to Run Macros see the following:
http://office.microsoft.com/en-us/ex...010031071.aspx
http://office.microsoft.com/en-us/ex...010014113.aspx
If help is still needed do a google search for 'youtube excel enable macro' and/or 'youtube excel run macro'.

To access Visual Basic (VBA) see:
http://www.ablebits.com/office-addin...a-macro-excel/
a. Click on any cell in the Excel Spreadsheet (may not be needed).
b. ALT-F11 to get to VBA.
c. CTRL-R to get project explorer (if it isn't already showing).
d. Double Click on a 'Module Name' in 'Project Explorer' to see code for that module.

Lewis

[GreekyGreek]

Thats perfect, exactly what I needed.

Thanks for your help Lewis!