Pivot Table

  • Thread starter Thread starter Joan
  • Start date Start date
Joan,

Please explain more about what you want to do.
Pivot Tables don't have an "IF" as such, but are very powerful and may be
able to handle your requirement still.

regards,

JohnI
 
There is two fields in the Pivot table I am creating
called G/L Account and Amount. The IF statement would
read: Enter the value of the Amount only if the G/L
Account = 123, if not, go to the next record.

Thanks, Joan
 
John,

I have another question regarding Pivot Table:
In my spreadsheet, I have a field labeled LAST NAME & a
field labeled FIRST NAME. Is there a way I can combine
both fields into one field and call it Name.
Thanks,Joan
 
Joan,

You can combine the fields back in the original data worksheet by adding a
new column with a formula like this-

=A2&" "&B2

This formula puts a space between the names.

Add the new grouped field to you PivotTable.

regards,

JohnI
 
Back
Top