Hi Guys,
I have a requirement to add vertical scrollbars to some very simple pivots I'm adding into a dashboard. Basically category and count columns only.
I've seen it done on dates horizontally (http://blog.contextures.com/archives/2013/02/28/update-pivot-table-with-scroll-bar/), I believe by filtering in some way, but I can't figure out how to use the same method to make it scroll/filter a pivot vertically with regular data.
I've uploaded my sample book, and highlighted the area I'd like to be shown on the screen.
Are there any ninja's that fancy a challenge and could help me out?
Thanks guys.
I have a requirement to add vertical scrollbars to some very simple pivots I'm adding into a dashboard. Basically category and count columns only.
I've seen it done on dates horizontally (http://blog.contextures.com/archives/2013/02/28/update-pivot-table-with-scroll-bar/), I believe by filtering in some way, but I can't figure out how to use the same method to make it scroll/filter a pivot vertically with regular data.
I've uploaded my sample book, and highlighted the area I'd like to be shown on the screen.
Are there any ninja's that fancy a challenge and could help me out?
Thanks guys.