• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot Table - Calculated Fields and Items

becha

New Member
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
 
Back
Top