Apr 20 2020 04:53 PM - edited Apr 20 2020 04:56 PM
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.
Apr 20 2020 05:37 PM
@Adrian1595 No worries. I figured out the answer to my question by myself.
It's called Splicer under Pivot Table Analyzer.
Thank you.