keep pivot table layout
Hello,
I made a pivot table with ranges from multiple worksheets. However, the
layout has become different. It now turns out Rows, columns, etc., instead of
my original ones, colour , country, styles, etc. I wanna have the original
ones as it also provides filter function even in pivot table, not the ones
which are static with wrong data. Pls help, if u have the solution or any
alternatives.
Thx!
|