Hello. I have two pivot table want one slicer control two pivot table.

Hello I need help with I am thinking making two pivot table. Slicer that control two pivot. Both pivot table header are Blue Line, Green Line and Purple how I get second pivot table change than pick on one slicer? I have two slicer merge into one slice how I do that?






Thanks You

Voyager22

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Better - thanks.

There are instructions at the top of the page explaining how to attach your sample workbook.

I have same question to

How I make them to work. both way with vba and without vba. I am new to pivot table?

Both pivot tables could be produced from one data source (LSW3 LEVLS sheet) providing a calculated field is added to the second pivot table as modeled on Sheet1.
The formula for the Kits I Need field is: =60 -'TOTAL KITS'
This way a slicer can control the output of both pivot tables.
Let us know if you have any questions.

Originally Posted by reachharry

Since the data source for both the pivots are different. In my opinion, without VBA it might be difficult to make one slicer to filter both pivot tables.

What is your suggestion I do? I am new to pivot table?

can you tell me in details how you make to work?

Are you asking reachharry or me?

I was talk about you JeteMc

Here is what I did.
1. Select a cell in Table1 on the LSW3 LEVLS sheet
2. Produce a pivot table such as the one in columns A:B of Sheet1 (same as the pivot table that you produced at the top of the LSW3 PIVOT TABLES sheet)
3. Again select a cell in Table1
4. Again produce a pivot table from Table1 (Table2 on the LSTW3 KITS not necessary)
5. For this second pivot table place color of lines in the Rows area and total kits in the Values area.
6. Select a cell in the second pivot table and then from the PivotTable Tools tab > Analyze sub tab select Fields, Items & Sets
7. Select Calculated Fields
8. You can name the field whatever seems reasonable (I used Kits I Need)
9. Clear the formulas window and then type = 60 -
10. From the Fields list select Total Kits and select Insert Field
Note that the Formula window should now display: =60 -'TOTAL KITS'
11. Select a cell in either pivot table and from the Analyze sub tab select Insert Slicer
12. Right click inside the slicer and then select Report connections
13. Select the check boxes for both pivot tables
Let us know if you have any questions.