Automatically generate multiple pivot tables from one pivot table

[leimst]

Hello,


I have a pivot table with sales information by manager. It seems like I recall that Excel has the ability to generate a separate pivot for each one of the managers at the touch of a button which results in additional tabs in the workbook that would be labled by manager. Am I making this up or is this the case?


Thank you in advance for any assistance,


Leimst

 

[Faseeh]

Hi lemist,


I think when you double click an item in Pivot table it will create a separate sheet for your showing the source data separately on that sheet? I think this is confusing you. You can try it yourself as well..


Regards,

 

[bobhc]

Good day leimst


Do not think you can do this, slicers will let you display data per manager in the pivot table, you could copy the pivot table and paste for each manager, this would make generating reports easier and each would up date as the raw data was up dated

 

[leimst]

Faseeh,


That is true but I believe that I have seen a technique that very simply and quickly produces a separate tab for each one of the managers. So in essence, if I had 10 managers, it would produce 10 tabs...one for each manager.


Thanks,


Leimst

 

[Faseeh]

Goto pivot table options, select the 2nd options that asks to show separate sheet for filtering filed and press ok, its is done.

 

[leimst]

That's it!!! Thank you very much Faseeh!!!


Have a great day,


Leimst

 

[Luke M]

Cool trick Faseeh, thanks for figuring this out. =)

 

[Faseeh]

Hi lemist & Luke,


Thanks alot