Hi Fausto,

Welcome to our forum!

I'm not sure what you mean by export, but if you double click on the grand total cell of the filtered PivotTable it will generate a new sheet containing the rows of data that make up that PivotTable. I hope that helps.

Mynda

Hi Mynda,

thank you very much, this is the solution I was looking for.  

Hi Mynda, 

I'm sorry but I realized that my problem is not completely solved.  I need to generate a new sheet that gives me the filtered data from 6 pivot tables.  with the double click in the grand total as you suggested I get the generation of a sheet that takes into account only One filter.

Hi Fausto,

It's not clear if the data in the 6 separate PivotTables comes from the same source data or 6 different sources? If it's coming from a single source, then why don't you create a single PivotTable that's connected to all Slicers/filters, so when you double click the grand total you get the data you want.

Mynda

Hi Mynda,

Yes, the 6 separate PivotTables comes from the same source data. I created a single PivotTable that's connected to all Slicers/filters as you suggested.

Sorry but when I double click one of the grand total in the pivot tables the new worksheet generated is filtered only with the filter related to the filter selected and not with all the filtered present in the worksheet.

I know that probably i am not so clear with my explanation....But I hope you can help me anyway.

Thanks

Hello,

Seems to me that you have multiple Pivot Tables and not one, but that is a guess. Can you upload a sample file?

Br,
Anders

Hello Anders,

Yes, you're right, actually  I put six pivot tables in the same worksheet. The problem is that if I select values ​​on each slicer I would like to generate a new worksheet containing only the rows of the datasheet in response to the selected filters.

Is there any possibility to do so?

Sorry but I can't upload the file.

Thanks

Sorry,

just a clarification,  I need the slicers at the same time to generate charts in a dashboard (already done) and to export filtered data in the worksheet mentioned in the previous post 

Thanks

Hello,

With six different Pivot Tables it is not possible to double click the grand total cell in one table and get a new sheet containing the filtered data from all tables, you will only get the data from the table you double click in. As Mynda suggested, if your data source for these tables are the same, why not create a Pivot Table that contains all the data that is now separated? If you need these six tables you currently have, create a seventh and connect it to the existing slicers.

Without a sample file it is difficult to give a good answer, as my reply is of course based on my assumptions and guesses.

Br,
Anders

Hi Anders,
thanks to the suggestions and solutions proposed by you and Mynda I solved the problem. Unfortunately I still have a problem left. When the new worksheet is generated by double clicking on the grand total, two columns of the datasheet  that contained values such as (33.6756 formatted as text) are transformed as (336756 formatted as General). Since this data is a geographic coordinate with this format it is no longer recognized by cartographic systems. Is there a possibility to keep the original format when creating the new worksheet? Thanks for the support.
Fausto

Hi all,

Problem solved. There was a problem in the collums format setting of the data sheet.