Hello, I'm new and I've tried looking for this answer everywhere.
I'm in the process of creating a dashboard with pivot table. I have huge data (included few in the attached file) so having a scroll bar will help visualize the data efficiently. I have referred few threads on adding scroll bar to pivot and attempted to incorporate it, but could not. I could not see data scrolling/moving along with bar (could not loop the data with scroll bar). can we do it only when we have numbers or counts included in the pivot? Any leads in resolving this would be greatly helpful!
Do we have any other option for the same?
In the attached file is a small sample of the source data, actual file has 1500+ entries.
Many thanks!
I'm in the process of creating a dashboard with pivot table. I have huge data (included few in the attached file) so having a scroll bar will help visualize the data efficiently. I have referred few threads on adding scroll bar to pivot and attempted to incorporate it, but could not. I could not see data scrolling/moving along with bar (could not loop the data with scroll bar). can we do it only when we have numbers or counts included in the pivot? Any leads in resolving this would be greatly helpful!
Do we have any other option for the same?
In the attached file is a small sample of the source data, actual file has 1500+ entries.
Many thanks!