Dear experts
I have master data workbook with huge data so i want create two pivot table from closed workbook source data reference to active workbook sheet!GSC
Pivot1
first pivot start with A10
Reportfilter! = DYP
Row Labels! =Type,Group of FPI
Column Labels!=Date,TERM
Values := Sum of Cost
Pivot2
second start at 5 row after end of first pivot.
Reportfilter!= DYP
Row Labels! =Type,Group of FPI
Column Labels!=Date
Values!= Sum of Cost
find the attachment of Masterfile and pivot requirement sheet!
Bookmarks