使用ssas在Excel 2007中进行透视 [英] Pivot in Excel 2007 using ssas

问题描述

你好，



我正在使用Excel 2007.我有几分钟的价值，现在我想为特定行标签平均那些值..但它给了我只有总和，我试图克服值，它打开值字段设置。但它禁用了夏天的功能...



任何帮助....请尽快帮助..

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..

推荐答案

您好Nirali，



您可以在Excel 2010中使用power pivot，您可以轻松地在数据透视表中使用数据功能。



你可以参考这个链接，以便了解它是如何工作的。



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





和



http://www.mssqltips.com/sqlservertip/2828/using-excel与ssas-cube / 进行交互[ ^ ]



问候，

Mubin Shaikh

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

这篇关于使用ssas在Excel 2007中进行透视的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！