I have a report that uses a pivotable.
There is a filter that encompasses the entire pivot table but is not the pivottable itself.
For what I am trying to do with this works great, However when certain slicers are chosen the pivot resets, rows move so the hiden rows no longer align with the...