Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Analysis Services (2000)  pb with measures.....

Author  Topic  argv666 Starting Member 1 Post Posted - 2005-07-04 : 09:34:08 Hi, I have a pb ... I have a column, named "scrap", and a column, "total qty". I have two dimensions, "date" and "scrap reason"... I want to do a percentage..."scrap"/"total qty"*100..... But the problem is that the total qty "is not linked" with the dimension "scrap reason" (of course, because it is the good ones). So, if you look at for the scrap reason '130', the percentage is wrong... I want to take the sum of scrap reason for each scrap code. For example, date : 2005/05/05 measures: scrap total qty % all reason code 45 100 0.45 '130' 20 (nothing here) 0.20 '131' 10 (nothing here) 0.10 '132' 15 (nothing here) 0.15 -------------- '131' : 20/100 '131' : 10/100 etc... Is it a way to do it? I hope you will understand me !! (oh, sorry for my english, but I'm french....) thank you for your help