Click here to Skip to main content
15,123,118 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello,

I am using Excel 2007. i have values in minutes, now i want to avg those values for particular row labels .. but it gives me only sum, i tried to clieck on values and it opens the value field settings. but it disable the functions for summerized...

Any help....please help asap..
Posted

1 solution

Hi Nirali,

You can use power pivot in Excel 2010 there you can use functions on your data in pivot table easily.

you can refer to this links for your reference to know how it works.

http://www.powerpivotpro.com/2010/06/using-excel-cube-functions-with-powerpivot/[^]


and

http://www.mssqltips.com/sqlservertip/2828/using-excel-to-interact-with-a-ssas-cube/[^]

Regards,
Mubin Shaikh
   
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900