Thank you so much for your help.
Do you know if it's still possible to just hide the items on the pivot table, rather than the whole row? The pivot table is part of a dashboard with other things to the side of it. So as rows are hidden, parts of the dashboard would disappear.
For now I could...
Hi Narayan,
Attached is a sample of what I have at the moment.
The aim is that the scrollbar should hide/unhide items from the pivot table so that only 12 (or 22 in my real worksheet) are visible at a time. To see what's going on, I substitute the Visible True/False property with a colour. So...
Just to clarify the pivot table layout a little better.
Category | Description | Status | Filter Field | ANOther Field
Cat1 | jfffmfmfmfm | Stat1 | No | jhfkfkffghfhgf
Cat1 | wdfafhktfhmf | Stat2 | No | ohgjkfghkfhgdfjh
Cat1 | ghdfjhdhkdk | Stat1 | Yes | ghfhjgfghfghdf
Cat2 | hgjhgjhgjhgj |...
Hi,
I have a pivot table that basically looks like this:
Category Description Status Filter ANOther
Cat1 jfffmfmfmfm Stat1 No jhfkfkffghfhgf
Cat1 wdfafhktfhmf Stat2 No ohgjkfghkfhgdfjh
Cat1...