dbTalk Databases Forums  

calculated member stuck up

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


Discuss calculated member stuck up in the microsoft.public.sqlserver.olap forum.



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

Default calculated member stuck up - 11-09-2004 , 08:40 AM






Hi,

I had a measure names price . I need to create a calculated member/cell
(i dont know till now ) to calculate price at that particular
cell/sum(price)

the formula is price/sum(price) ... My doubt is how can i take the sum
function to calculate the total price (even it is showing in the ALL
column) ...on the same measure..

I tried using the sum, aggregate functions... but i couldnt make it
done. please try to sort this one out for me.

Thanks in Advance.

Neo

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Reply With Quote
  #2  
Old   
Neo
 
Posts: n/a

Default Re: calculated member stuck up - 11-09-2004 , 08:00 PM






sorry folks,

I came to know that i asked a silly question and i got the answer for
that. i just created a calculated member sum(price) based on [time][all]
and then created another calculated member %price.

Neo

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

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.