How can I have floating sub pivot table within Pivot Table Worksheet?

Brass Contributor

Let's suppose I have the name of the top ten stock and associated data.

 

Now if I choose Stock name and face value for that day or average of value for three or six or twelve months in a pivot table I want to see particular data in a separate floating tiny scroll-able window with Stock name and value for particular time when chosen separately. By the way I have the data on a separate worksheet in the same file.

 

Or just the stock name and average of last three months or last six months or twelve for that matter.

 

How can I make a separate floating window that is all I want to know filled with necessary data?

 

Thank you respected Community Members.

 

1 Reply

@Adrian1595 No worries. I figured out the answer to my question by myself.

 

It's called Splicer under Pivot Table Analyzer. 

 

Thank you.