Regarding Consolidation of Multiple Table with Item Value

[vishal thakral]

Dear All,
Myself Vishal Thakral, from Nagpur, Maharashtra, India. I want a Pivot Table which consolidates multiple Tables.
The Columns are as below:-
Date
Item
Issued kgs
Received kgs

I want a Pivot Table as below:-
Filter 1 = Person
Filter 2 = Date
Rows = Items
Value 1 = Issued (Column 1)
Value 2 = Received (Column 2)

I have attached a Test Workbook.

Kindly do the needful and revert

Thanks in advance,
Vishal Thakral

 

[bosco_yip]

Try…..

In "Reports Sheet" J5, copy across and down :

=IF(($J$1="Person1"),SUMIFS(Entries!C:C,Entries!$A:$A,$J$2,Entries!$B:$B,$I5),SUMIFS(Entries!H:H,Entries!$F:$F,$J$2,Entries!$G:$G,$I5))

Regards

 

[srinidhi]

HI,

If you need only a pivot table, you need to re-arrange the data & then apply pivot on it. Attached the file for your reference.

 

[vishal thakral]

HI,

If you need only a pivot table, you need to re-arrange the data & then apply pivot on it. Attached the file for your reference.

I dont want to input "Person" details everytime i pass an entry, thats why I created PERSONWISE Tables.

The entry format is given in my attachment, which i cannot change.
i.e. Individual Table Person Wise