Use the displayed value (Show Values As) in a New Measure

[loaizaprat]

I have a PowerPivot table in which one of the columns is displayed as % of Parent Row Total. I want to take that % and use it in a New Measure for the PowerPivot Table.

For instance:

Field 1 Value Field 1 Showed As % Field 2
Row 1 10 25% 100

I want a New Measure that multiples 100 * 0.25 but all I get is 100 * 10.

Any ideas will be appreciated.

Thanks in advance.

 

[scottsen]

Hmmm... my only guess would be those function were added after your current version of Power Pivot. Can you update?

 

[loaizaprat]

I could only find version 10.50.4000, which is the one I have installed.

Which version do you have?

 

[scottsen]

For Excel 2010? Download Microsoft® SQL Server® 2012 SP1 PowerPivot for Microsoft Excel® 2010 from Official Microsoft Download Center should be 11.0.3000.0

 

[loaizaprat]

For Excel 2010? Download Microsoft® SQL Server® 2012 SP1 PowerPivot for Microsoft Excel® 2010 from Official Microsoft Download Center should be 11.0.3000.0

Thank you so much Scott! I updated the version of PowerPivot and it now works just like I needed it.