how to avoid the report from total up the value? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

how to avoid the report from total up the value?

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.
You can use the ClosingPeriod MDX function in a Calculated member at the month level. Raulie
]]>