pivotable drill down

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created a pivotable that queries an external database that contains
sales and cost fields. I would like to create a margin (sales - cost) field
and have it be available when drilling down in the pivotable. Thank you.
 
If you double-click on a pivot table cell, it shows fields from the
source data. If you create the field in the external database, it will
be available when you drill to details.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table drill down sort 0
match two conditions to return value from pivot table 1
Pivot Table with Percentages 4
Automatically Update a Pivot Table Field Used as Column / Row 1
Creating a Calculated Field in a Pivot Table for same field 3
Pivot Table - '% of Total' question 2
Pivot grand total 1
Macro to Format the Pivot Table drill down 4

Back
Top