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)  how to avoid the report from total up the value?

Author  Topic  tyme Starting Member 10 Posts Posted - 2007-06-04 : 21:49:31 Hi everyone...i've created an olap report using the pivottable in excel which contain data like opening and closing balance...the closing balance for today will be the opening balance for the next day...the report is correct if i select data based on day..but there's problem when i select data based on month or year, the report will total up the opening balance of that month/year, which is wrong...the opening balance of that month suppose to be the same as the closing balance of the day before..so what should i do so that the report will always take the closing balance as the opening balance?..is there anything i need to do with the cube?..thank you.