dbTalk Databases Forums  

Problem in Creating a Calculated Measure With Filter

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


Discuss Problem in Creating a Calculated Measure With Filter in the microsoft.public.sqlserver.olap forum.



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

Default Problem in Creating a Calculated Measure With Filter - 12-19-2004 , 06:37 PM






Dear all,
If I have a cude named employee,with a measure named amount. When I
select a member of date dimension, [2004].[Half Year],now the amount is 1200.
How can I create a calculated measure which equals the total amount of
employees before [2004].[Half Year]??

Thanks & Best Regards!!
Phoenix

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.