Pivot Table Calculated Field Issue

[Amolvijay]

Hi Experts,
Request your help. I have a database with multiple items. I want to create a pivot summary sheet. When I go for Calculated field Item in pivot table, the row section gets populated for all the Customers irrespective of of its relation with Vertical item...Attached please find the sample excel for your kind reference. The calculated field is summation of Offshore and Onsite revenue numbers.

In the "With Field Item" tab I have highlighted the ROWs with ORANGE, those shouldn't be there for each of the vertical.

The expected result is to have another FIELD which is summation of Offshore and Onsite...with only Customer details against the Vertical

Untitled.png