[TABLE="width: 356"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 4"]Pivot Table[/TD]
[/TR]
[TR]
[TD="align: left"]Date:[/TD]
[TD]11-12-18[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]Item Name[/TD]
[TD="align: left"] Opp.[/TD]
[TD] Qty In[/TD]
[TD] Qty Out[/TD]
[/TR]
[TR]
[TD]Bearings[/TD]
[TD] ?[/TD]
[TD] 0[/TD]
[TD] 7[/TD]
[/TR]
[TR]
[TD]Belt[/TD]
[TD="align: center"]?[/TD]
[TD] 0[/TD]
[TD] 3[/TD]
[/TR]
[TR]
[TD]Cutter Blade[/TD]
[TD="align: center"]?[/TD]
[TD] 0[/TD]
[TD] 2
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: center"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: center"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I am using a pivot table report and date is my report filter here is want to item opening balance.
how it is possible
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 4"]Pivot Table[/TD]
[/TR]
[TR]
[TD="align: left"]Date:[/TD]
[TD]11-12-18[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]Item Name[/TD]
[TD="align: left"] Opp.[/TD]
[TD] Qty In[/TD]
[TD] Qty Out[/TD]
[/TR]
[TR]
[TD]Bearings[/TD]
[TD] ?[/TD]
[TD] 0[/TD]
[TD] 7[/TD]
[/TR]
[TR]
[TD]Belt[/TD]
[TD="align: center"]?[/TD]
[TD] 0[/TD]
[TD] 3[/TD]
[/TR]
[TR]
[TD]Cutter Blade[/TD]
[TD="align: center"]?[/TD]
[TD] 0[/TD]
[TD] 2
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: center"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: center"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I am using a pivot table report and date is my report filter here is want to item opening balance.
how it is possible