Pivot Table Formula help
To be clear, 'Time Type' and 'Employee or Source' are in the ROW part of the
pivot table. Maybe one can only use an if statement on data values in the
COLUMN part of the PT?
"xrbbaker" wrote:
Do "if" statements work in a Pivot Table formula? If so can I nest them like
in "regular" excel? I have the following formula and I don't get any syntax
error, but it doesn't work. I need this behavior in the pivot report, not in
the underlying Range.
=IF('Time Type'="actual",May*184,IF('Employee or
Source'="external",May*160,May*120))
Thanks - Russ
|