Hi this is going to be hard to describe, I am trying to format a pivot table that looks like this (where the x represent a border line)(dots are white space)
Code x Description x Total
A..... x Work on A. x 12.00
........x Allowance.. x 5.00
A Total................. 17.00
B ......x Work on B. x 20.00
.........x Allowance .x 3.00
B Total ...................23.00
Grand Total .............40.00
As i change the data source and it picks up new rows the table i.e C or other considerations for A and B and I refresh the table the border line between Code and Description continues to follow the pattern set before it, however the one between desciption and total doesn't. I was wondering if anyone knew what may be causing one side to work and the other side not to. Cheers
Code x Description x Total
A..... x Work on A. x 12.00
........x Allowance.. x 5.00
A Total................. 17.00
B ......x Work on B. x 20.00
.........x Allowance .x 3.00
B Total ...................23.00
Grand Total .............40.00
As i change the data source and it picks up new rows the table i.e C or other considerations for A and B and I refresh the table the border line between Code and Description continues to follow the pattern set before it, however the one between desciption and total doesn't. I was wondering if anyone knew what may be causing one side to work and the other side not to. Cheers
Last edited:
