Hi All,
I have a pivottable with multiple items in the column section. I have tried modifying the pivottable using the Pivottable styles editor but can't seem to get what I want to achieve to work and would appreciate any advice
I have put a picture below with two examples (with made up data)
As you can see I have two items in the "Column" section. "Country of origin" on the first row, followed by a "number" on the second row.
I want to put borders down the side of each column based on where the Country column ends rather than on every single column. I have done an example in the second table below on what I want to achieve but I want it to work with data moving as the pivot table.
Any advice is really appreciated
I have a pivottable with multiple items in the column section. I have tried modifying the pivottable using the Pivottable styles editor but can't seem to get what I want to achieve to work and would appreciate any advice
I have put a picture below with two examples (with made up data)
As you can see I have two items in the "Column" section. "Country of origin" on the first row, followed by a "number" on the second row.
I want to put borders down the side of each column based on where the Country column ends rather than on every single column. I have done an example in the second table below on what I want to achieve but I want it to work with data moving as the pivot table.
Any advice is really appreciated