Forum Discussion

Adrian1595's avatar
Adrian1595
Brass Contributor
Apr 20, 2020

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

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's avatar
    Adrian1595
    Brass Contributor

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

     

    It's called Splicer under Pivot Table Analyzer. 

     

    Thank you.

Resources