Log In
Register
Home
January 17, 2021
Offline
I realized an excel dashboard based on 6 pivot tables. I need to export only the rows in the datasheet resulting from the filtered data selecterd from the slicers in the dashboard. Is there any method to do so easily? Thanks
See Answer
July 16, 2010
Offline
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
Answers Post
January 17, 2021
Offline
Hi Mynda,
thank you very much, this is the solution I was looking for.
January 17, 2021
Offline
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.
July 16, 2010
Offline
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
January 17, 2021
Offline
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
VIP
Trusted Members
December 7, 2016
Offline
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
January 17, 2021
Offline
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
January 17, 2021
Offline
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
VIP
Trusted Members
December 7, 2016
Offline
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
January 17, 2021
Offline
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
1 Guest(s)
