Hello all,
I have an excel (2016) workbook with a direct connection to an SSAS cube. I need to combine two or more cubevalue formulas in order to sum two different values or sometimes more.
For example I want the formula to return the sum of Sales and Cost of Sales. Currently I do it like this:
==CUBEVALUE("Corporate Financial Consolidation Model",$C$1,$A11,CUBEMEMBER("Corporate Financial Consolidation Model","[Account].[CorporateAcct].["&$C12&"]")+CUBEVALUE("Corporate Financial Consolidation Model",$C$1,$A11,CUBEMEMBER("Corporate Financial Consolidation Model","[Account].[CorporateAcct].["&$D12&"]")
Where C12 = Sales and D12= Cost of sales
I know that you can use the Cubeset formula to combine both Sales and Cost of sales and simplify the formula. Sometimes I want to add 3 or more accounts.
Can someone help me with that formula?
Thank you all
I have an excel (2016) workbook with a direct connection to an SSAS cube. I need to combine two or more cubevalue formulas in order to sum two different values or sometimes more.
For example I want the formula to return the sum of Sales and Cost of Sales. Currently I do it like this:
==CUBEVALUE("Corporate Financial Consolidation Model",$C$1,$A11,CUBEMEMBER("Corporate Financial Consolidation Model","[Account].[CorporateAcct].["&$C12&"]")+CUBEVALUE("Corporate Financial Consolidation Model",$C$1,$A11,CUBEMEMBER("Corporate Financial Consolidation Model","[Account].[CorporateAcct].["&$D12&"]")
Where C12 = Sales and D12= Cost of sales
I know that you can use the Cubeset formula to combine both Sales and Cost of sales and simplify the formula. Sometimes I want to add 3 or more accounts.
Can someone help me with that formula?
Thank you all