Replies

Hans, this didn’t work… I am wanting to add an extra column to calculate this…

Does this change your answer???

Mitch

Click in the pivot table.
Start the Pivot Table Wizard.
Click Layout…
Add the Amount field to the Data area, since there is already an instance of Amount there, the new one will be called Sumof Amount2.
Double-click the Sum of Amount2 button.
Change the name if you like, then click Options>>.
From the “Show data as” dropdown, select “Difference with”.
Select LE in the Base Field list.
Select (previous) in the Base Item list.
Click OK, OK, Finish.

Note: I want to add the column w/the subtraction and title it variance…

You can’t use the data fields of the pivot table in a calculated field.

It might be helpful of you posted (a stripped down copy of) your workbook, with an indication of what you want.

Ok. Here is a picture. I want to subtract the March LE data from the December LE data – column f from column e.

You can’t use the data fields of the pivot table in a calculated field.

It might be helpful of you posted (a stripped down copy of) your workbook, with an indication of what you want.

I think I want to calculate an item because those fields don’t come up as options. So, don’t I want to do this instead of calculate a field??

You did not mention the Excel version. FOr 2003 and below: click anywhere in the pivot table. Then on the pivot table toolbar, select PivotTable, Formulas, Calculated field. That dialog speaks for itself I think.

Hans, I forgot to ask… What if I only want to print “visible” worksheets and not print hidden???

Thanks.

The following macro will print all sheets in the activeworkbook:

Sub PrintEmAll()
ActiveWorkbook.PrintOut
End Sub

You can assign this macro to a custom toolbar button, or place a button from the Forms toolbar on a sheet and assign the above macro to it.

Works great! You are marvelous w/Excel!

Thanks so much.

Mitch

Don’t see this as option. Tried all I see and no go… Tried saving as various file types… No luck

thx.

I attached file with a short highlighted note on the Pivot table as to what I am trying to do.

I try the the comments in the actual pivot table and I got no changes. I was wanted to do a subtotal at every change in the G/L account.

I double clicked on G/L account, automatic under subtotals and then closed out of dialog. It doesn’t calculate a subtotal at each change in G/L account.

What do you mean by the “data in column A should be repeated for this.”

I do this (automatic under subtotals) and nothing happens. Ideas?

Awesome! Thanks.

Amazing!

Using this same process, how would I extract the first name from this?

Works great after I put in right reference!!!!

Thanks.