Create a Calculated Field.

Shafique

New Member
Joined
Nov 23, 2018
Messages
29
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.
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Watch MrExcel Video

Forum statistics

Threads
1,099,122
Messages
5,466,818
Members
406,500
Latest member
Tknotmaxx

This Week's Hot Topics

Top