G
Guest
Guest
I'm trying to use a custom pivot table formula with an "if" command. Can I set up a pivot table field that basically says, if field1="yes", then field2*field3, else 0 and thereby get the sumproduct of fields 2 and 3 wherever field 1 is equal to "yes". This would seem to be more logical than creating intermediate fields in my database.
Thanks
Thanks