Pivottables - tailored grand totals

  • Thread starter Thread starter johnb
  • Start date Start date
J

johnb

I have material unit cost and units with a calculated
field of cost * units at the detail level. Question how do
I tailor the grand totals for total units and cost? The
present PT give total unit, total units cost and total
costs * total units which wrong.

TIA

johnb
 
johnb,

You need to add a column to your pivot table source, that includes a column
cost*units.

HTH,
Bernie
MS Excel MVP
 
You must log in or register to reply here.

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

Dynamic Table Problem 1
Determine which variable was used in a calculation. 2
Need to know the % of a grand total 1
Hide Pivottable GrandTotal using VB 4
pivot table grand total 2
PivotTables and xlPercentOfTotal 6
autsum several fields 2
ON SUBTOTAL LINE CARRY FORWARD DENOMINATOR FROM PREVIOUS LINE 1

Back
Top