Hi Guys,

For your kind assistance please.

I’m having problem creating a pivot table from multiple worksheets. It’s not showing the correct labels that I want. I have two worksheets namely “Open” and “Closed” with same labels of information like Date Created, Age, Source, Status etc. But when I performed Alt+d+p, choose “Multiple consolidation ranges” > “I will create the page fields” > and then I add Range coming from the two worksheet and then I choose “Existing worksheet” and the click on “Finish”, but the problem is I’m only getting from the PivotTable Field List is “Row” “Column” and “Value”, I can’t customize my pivot table to the specific labels I want coming from the two worksheets.
Please Help!