Multiple Pivot tables from one data source - only show certain columns of data per pivot table

Question

Hello,

I have one data source that I am pulling information from, this data source has many columns (A to BL). I have created multiple pivot tables from this one data source and would like each pivot table to only show certain columns when selected. For example, if I select a certain data to view from "Pivot Table A" I would only like it to show columns A to F from the data source, if I select to view data to view from "Pivot Table B" I would only like it to show columns A to D and G to L.

Is this possible, or do I need to create a separate data source for each pivot table to achieve this?

FYI I'm working with Microsoft 365

Thanks!

Answer 1

You may share it as attachment in private message.

Answer 2

Unfortunately I can't seem to find an option to add or upload a file here.

Answer 3

Could you share some dummy data and expected result with separate data source? Then we may try it with same data source.

Answer 4

Thanks for the response, but this did not achieve what I'm looking for.

Answer 5

Copy your povit table to another workbook and copy back. This will remove the connections between the povit tables.