dbTalk Databases Forums  

Do not want to sum all columns

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


Discuss Do not want to sum all columns in the microsoft.public.sqlserver.olap forum.



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

Default Do not want to sum all columns - 04-11-2004 , 07:14 PM






I have a cub that looks like this:

year - month | prior year carry over total | hours | [prior year carry over
total + hours]

2004 - Total 300 | 14 | 314
Jan 100 | 4 | 104
Feb 100 | 3 | 103
Mar 100 | 7 | 107

but I need it to look like this:

2004 - Total 100| 14 | 114
Jan 100 | 4 | 104
Feb 100 | 3 | 103
Mar 100 | 7 | 107

The [prior year carry over total] should only be counted once per year and
not summed like it is doing now. How can this be accomplished?

Thanks



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.