Question on Calculated fields and items in PP 2010

[tbobolz]

Hi, after reading many post, it seems the solution to calculated fields in Excel 2010 is to create a calculation in DAX of the data table. After I do this and create a need column the PP table will not allow me to drag it innto the "values" field of the field list table. I am using numbers in this field. Is there a better solution to mirroring the function of caluclated field and items that use to exsist in the basic pivot tables of excel?

Did they bring back this function in Excel 2013?

Thanks for any help you can offer.

Terry


Windows 7, Excel 2010

 

[Tycho01]

Plugin DAX Studio allows you to populate Excel sheets using DAX/MDX queries. It might not be the same, but have you looked into if that fulfills your requirement?

 

[tbobolz]

Thanks Tych01,

Yes I have been studying them as we speak, hopefully I can learn them quickly. I was hoping i missed something obvious in 2010, as I did not think this a an item that Excel would have done away with for the average user.

Thansk again

Terry

 

[RoryA]

The average user doesn't use PowerPivot; they use regular pivot tables where calculated fields and item still exist. (in 2013 they've decided to rename measures "calculated fields" just to help confuse )

 

[tbobolz]

Ok, thanks, guess I'm stuck in a learning curve as i am between average and PP, HA, The learning process will be good for me, ultimately.

Thanks
Terry

 

[RoryA]

Just remember that essentially PP measures are the equivalent of 'regular' calculated fields and PP calculated columns are the equivalent of 'regular' calculated items.

 

[tbobolz]

Rory,

I think i just realized that these feature are not available in Excel 2010, or do I need to include another add-in? I do not have a "measures" options in my home tab. Or do I need to upgrade?

Thanks again

 

[RoryA]

Measures can be created in the grid below each table, or in the PP field list back in the main Excel UI.