none
Calculated fields in Pivot Table Excel Report (2010)

    Question

  • Hi,

    Obviously, the "Insert Calculated Field" is not available in evry Excel Report in the "Fields, Items & Sets" command (2010).

    What are the rules about this feature?

    Thanks 

    Monday, January 10, 2011 10:07 PM

Answers

All replies

  • Hi WLID1966,

    you can create a calculated field from the OLAP Cube configuration settings and insert in to one of the cube. And the field will appear for you when you use cube in excel to create report ?

    incase i understood your question wrong, please explain bit more then :)

     


    | Khurram Jamshed | Follow my blog about Enterprise Project Management Solution | http://khurramjamshed.blogspot.com |
    Tuesday, January 11, 2011 5:19 AM
  • Hi,

    in addition to Khurram's suggestion, you could try the following. It helped me, when I had the same question: http://olappivottableextend.codeplex.com/.

    The version I installed has an issue with language, see http://olappivottableextend.codeplex.com/workitem/18746. I don't know if it is still the case, so you will  need to try, I 'am afraid.

    Good luck!
    Barbara

     

    Tuesday, January 11, 2011 6:37 AM
    Moderator
  • Hi  everybody,

    What I want is to use the Excel built-in feature that we find in a pivot table sheet: (Pivot Table Tools ribbon)

    Tab: Options

    Drop down list : Calculations

    Button : Fields, Items & Sets

    Command : Calculated Field  (but this command is grayed out)

    In the French version you can see that: http://www.cijoint.fr/cjlink.php?file=cj201101/cijhrJOOmD.jpg

    Thanks

     

     

     

    Tuesday, January 11, 2011 10:36 AM
  • Hi,

    I understand that you don't want to install an additional tool. However, as Andrew wrote in an answer at http://social.technet.microsoft.com/Forums/en-US/projectserver2010general/thread/40f102b4-07b7-433d-9170-cb8a5ce36318:

    ".... that you can't add custom calculated fields to
    a PivotTable generated from an OLAP cube
    - or that may be when driving a
    PivotTable directly from an OLAP cube in SSAS (can't remember).
     
    Luckily, there's a Codeplex add-in for just such an issue....the Excel PivotTable
    OLAP Extender: http://olappivottableextend.codeplex.com/"

    That was the only way I could solve the same issue.
    Regards
    Barbara

    • Marked as answer by WLID1966 Tuesday, January 11, 2011 11:20 AM
    Tuesday, January 11, 2011 11:08 AM
    Moderator
  • Thanks Barbara,

    I think I'll try to keep it simple : as Khurram suggest, I'll try to create the custom field in PWA before creating the Excel Report...

    But can we have Calculated fields as Measure in an OLAP cube?

    Tuesday, January 11, 2011 11:29 AM
  • Yea WLID1966, the calculated field you will create will be inserted in the cube as measure.
    | Khurram Jamshed | Follow my blog about Enterprise Project Management Solution | http://khurramjamshed.blogspot.com |
    Tuesday, January 11, 2011 12:09 PM