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

%3CLINGO-SUB%20id%3D%22lingo-sub-1323156%22%20slang%3D%22en-US%22%3EHow%20can%20I%20have%20floating%20sub%20pivot%20table%20within%20Pivot%20Table%20Worksheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1323156%22%20slang%3D%22en-US%22%3E%3CP%3ELet's%20suppose%20I%20have%20the%20name%20of%20the%20top%20ten%20stock%20and%20associated%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20if%20I%20choose%20Stock%20name%20and%20face%20value%20for%20that%20day%2C%20average%20of%20value%20for%20three%2C%20six%20and%20twelve%20months%20in%20a%20pivot%20table%20I%20want%20to%20see%20particular%20data%20in%20a%20separate%20floating%20tiny%20scroll-able%20window%20with%20Stock%20name%20and%20face%20value%20for%20that%20day%20when%20chosen%20separately.%20By%20the%20way%20I%20have%20the%20data%20on%20a%20separate%20worksheet%20in%20the%20same%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOr%20just%20the%20stock%20name%20and%20average%20of%20last%20three%20months%20or%20last%20six%20months%20or%20twelve%20for%20that%20matter.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20make%20a%20separate%20floating%20window%20that%20is%20all%20I%20want%20to%20know%20filled%20with%20necessary%20data%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20respected%20Community%20Members.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1323156%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1323202%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20have%20floating%20sub%20pivot%20table%20within%20Pivot%20Table%20Worksheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1323202%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F413290%22%20target%3D%22_blank%22%3E%40Adrian1595%3C%2FA%3E%26nbsp%3BNo%20worries.%20I%20figured%20out%20the%20answer%20to%20my%20question%20by%20myself.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20called%20Splicer%20under%20Pivot%20Table%20Analyzer.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
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
Highlighted

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

 

It's called Splicer under Pivot Table Analyzer. 

 

Thank you.