**How to remove multiple rows in pivot table??**

[Anonymous]

Hi,

In a pivot table when i select a year i want the sales for previous,current and next years to be displayed like below.

But when i add expressions for previous and next year sales am getting mutliple rows of sales for 2014Sales and 2015Sales

Can someone please help me fix this.

Thanks!