Complicated Pivot table

[Ecel Dumbo]

Hello,


Please see the attachment and please advise on how to build a pivot table from the shown source data without making any changes to the structure of the source data.


http://speedy.sh/Dr9JQ/Complicated-Pivot-Table.xls


Thanks

Dumbo

 

[Faseeh]

Hi Dumbo,


I donot think you can create a pivot this way, but you can use sumproduct() to achieve similar results, try this enter in Source Data:


=SUMPRODUCT(('Source Data'!$D$3:$D$10='Pivot Table'!$A$6)*('Source Data'!$P$2:$AA$2='Pivot Table'!C$5)*('Source Data'!$P$3:$AA$10))


and drag to right.


.Faseeh

 

[koi]

Hi,


maybe like this? http://speedy.sh/UM8bV/Copy-of-Complicated-Pivot-Table.xls

 

[Ecel Dumbo]

Thannks a lot Fasseh and Koi. Both ways serves the purpose. thanks heaps