hi
i have created a pivot table see below, how do i get it to not show the empty rows
<colgroup><col><col><col></colgroup><tbody>
</tbody>
As you can see, it is showing Anglian water, cannon and HCC, how do I get these lines not to show?
Regards
Stephen
i have created a pivot table see below, how do i get it to not show the empty rows
| Row Labels | Sum of M&S/Aldi/Retail | Sum of Total |
| June 30 2018 | £2,278,809.34 | $4,266,749.10 |
| Anglian Water | $4,782.58 | |
| Bidwells | £6,583.50 | $18,788.25 |
| BLP Insurance | £5,000.00 | $5,000.00 |
| Breheny | £1,837,112.10 | $3,282,004.70 |
| Cannon | $1,698.75 | |
| Farrell & Clark | £134,110.00 | $159,771.00 |
| Ground Control | £2,950.00 | $2,950.00 |
| HCC | $27,210.16 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
As you can see, it is showing Anglian water, cannon and HCC, how do I get these lines not to show?
Regards
Stephen
