Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: Excel 2007 SSAS
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-May-13 19:40pm

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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
  Permalink  
v2

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

  Print Answers RSS
0 OriginalGriff 539
1 Maciej Los 300
2 DamithSL 233
3 Sergey Alexandrovich Kryukov 209
4 BillWoodruff 200
0 OriginalGriff 7,168
1 Sergey Alexandrovich Kryukov 6,377
2 DamithSL 5,461
3 Manas Bhardwaj 4,876
4 Maciej Los 4,450


Advertise | Privacy | Mobile
Web03 | 2.8.1411023.1 | Last Updated 3 Sep 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100