Pivot Table

[Joan]

Is there a way to have an IF function in a Pivot Table ?

 

[JohnI in Brisbane]

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

 

[Joan]

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

 

[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

 

[JohnI in Brisbane]

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