hi everyone. 2 Qs to anyone outthere willingly to help!
1st.-is it possible to create a calculated field formula using a conditional function such as IF and referencing to other Field Names and/or Item Names BESIDES the Field in which the formula or calculated item is being inserted on?
2nd.-how can the additional fields created by the Group Command Option on a Pivot Table be Deleted from the PT?
Im not talking about removing them from the PT (but still show on the Field List Window) but actually to erase them off the Pivot Table (?)
thanks in advanced 4 your shared knowledge
1st.-is it possible to create a calculated field formula using a conditional function such as IF and referencing to other Field Names and/or Item Names BESIDES the Field in which the formula or calculated item is being inserted on?
2nd.-how can the additional fields created by the Group Command Option on a Pivot Table be Deleted from the PT?
Im not talking about removing them from the PT (but still show on the Field List Window) but actually to erase them off the Pivot Table (?)
thanks in advanced 4 your shared knowledge