SQLServerCentral » Data Warehousing » Analysis Services » How do I calculate the subtotal for a calculated column using the subtotals of the other columns used in the calculation?InstantForum 2016-2 FinalSQLServerCentralhttps://www.sqlservercentral.com/Forums/SQLServerCentralSun, 22 Jan 2017 20:07:25 GMT20How do I calculate the subtotal for a calculated column using the subtotals of the other columns used in the calculation?https://www.sqlservercentral.com/Forums/FindPost1494881.aspx
I have in the underlying database a column computed from other values in the same row.
In ssas all these columns are automatically summed to provide the subtotals as I drill down hierarchies.
However, rather than summing the computed column values I need to perform the computation again in ssas using the subtotals of the other summed columns.
I am new to ssas but I have a sense that this is probably a common problem with a generic answer but I cannot find an example of how to do this.
Wed, 25 Sep 2013 12:20:14 GMTdescahillRE: How do I calculate the subtotal for a calculated column using the subtotals of the other columns used in the calculation?https://www.sqlservercentral.com/Forums/FindPost1498532.aspxThe solution was a calculated member - I realised this is what they are for!Wed, 25 Sep 2013 12:20:14 GMTdescahillRE: How do I calculate the subtotal for a calculated column using the subtotals of the other columns used in the calculation?https://www.sqlservercentral.com/Forums/FindPost1495064.aspxMore information is needed to see what you are doing. A picture of what you currently see would also be helpful.Mon, 16 Sep 2013 07:14:06 GMTRonKyleRE: How do I calculate the subtotal for a calculated column using the subtotals of the other columns used in the calculation?https://www.sqlservercentral.com/Forums/FindPost1495022.aspxI think an example of what you are trying to accomplish may help. However, based on what you noted so far, you may be able to look at creating a calculated member to sum your two values. SSAS does not handle aggregates of aggregates in a straight forward method.Mon, 16 Sep 2013 05:54:00 GMTScott Murray-240410