Hello, I am using Excel 2010, Windows 7, with PowerPivot Version 10.50.4000.0. I am required to use this version due to posting of data to our sharepoint environment and server configurations (not Ideal I know). My issue is as follows: I would then like to display via a powerpivot table the following: I am having trouble getting y and am lost in my own nested calculate and sumx functions. Appreciate any help/suggestions provided. Thank you, Dan

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Averaging Averages for distinct values as a calculated measure

Thread starter Flexdex
Start date Sep 26, 2013

Flexdex

New Member

Sep 26, 2013

Hello,
I am using Excel 2010, Windows 7, with PowerPivot Version 10.50.4000.0. I am required to use this version due to posting of data to our sharepoint environment and server configurations (not Ideal I know). My issue is as follows: