My first ever post, hopefully I am clear enough but any feedback great appreciated.
The gist of my issue;
• I have a pivot table with 9 expressions
• Also has 6 dimensions (not sure if this is relevant)
• As result of the data set the table contains 60 rows and 5,617 columns when no filters are applied
I have a horizontal scrollbar which is working as you would expect. However I really need to be able to force the scroll bar to jump 9 columns at a time, not the standard 1. In effect, the 9 expressions are all linked to a specific product that we sell and for visual / end user ease I would like them to effectively be scrolling through a product at a time.
I’m afraid internal policy states that I am unable to share this document, even scrambled (sorry, I know this will hinder any aid).
Also, if there are better ways of doing this I’m more than happy to take a different approach, all help gratefully received!
Thanks in advance, hopefully I can repay the favour to somebody as my skills develop.
