dbTalk Databases Forums  

Show Average in Excel Value Field

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Show Average in Excel Value Field in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Thomas Kunz
 
Posts: n/a

Default Show Average in Excel Value Field - 11-04-2005 , 02:17 AM






Hi

When I display a Mesure Fiel from the Cube in Excel it is allways the summ
of the Values.
But i Need to show die Average Value.

Thanks

Thomas Kunz



Reply With Quote
  #2  
Old   
Sophie Guo [MSFT]
 
Posts: n/a

Default RE: Show Average in Excel Value Field - 11-04-2005 , 04:41 AM






Hello,

The answer depends on what average value you want to calculate. You can
create a Calculated Members. For example, the Sales cube in the FoodMart
2000 database contains a Calculated Member called Sales Average.

I hope the information is helpful.

Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.