Forum Discussion
Guy_Lenaerts
Mar 05, 2020Copper Contributor
Generate report filter pages Pivot tables
In order to send data to different users, I need to generate pages from a pivot table. This has to be done, so that no user can have access to the filtered data Can this be done without protecting ...
Abiola1
Mar 05, 2020MVP
To generate individual report in PivotTable, drag and drop desired field into the Filter area.. Then, on the options dropdown of the Analyze tab, click on Show Report Filter pages..
This would create multiple report pages based on the filter.. Then, you can finally email the individual sheet tabs to different users
This would create multiple report pages based on the filter.. Then, you can finally email the individual sheet tabs to different users
seydinabia
Aug 28, 2022Copper Contributor
Hello Everybody
Hope you're all find. Please I've a problem with report filter option on pivot table. Generate button option is deactivated even though I've already put a column in filter field. Could you help please?
Great thanks
Seydina
Hope you're all find. Please I've a problem with report filter option on pivot table. Generate button option is deactivated even though I've already put a column in filter field. Could you help please?
Great thanks
Seydina
- seydinabiaSep 20, 2022Copper Contributor
Hello everybody
Does anyboy know how do I have to proceed for my report filters?
Thanks in advance