Create a Calculated Field.

[Shafique]

Date: 20-10-19 <-----Report Filter Daily Out ward Detail

Item Name: Item Type: Item Size Qty. Balance
PIPE PVC 2" 001 ?????
PIPE PVC 3" 001 ?????
PIPE IRON 2" 005 ?????



In my New Pivot Table Report I am generating different Store Items daily in and outward Detail as shown.
And the data source is same table(Entry) for in ward and out ward pivot table report. Because I created IN Column And OUT Column in same Table(Entry). Here I want the Item Balance According Its Item Type And also Its Item Size.

 

[James006]

Hello,

To learn how to add a calculated field, take a look at Debra's excellent site :

https://www.contextures.com/excel-pivot-table-calculated-field.html

Hope this will help

 

[Shafique]

i cannot find my solution. e.g getdata using SUMIFS