Home Forums 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? RE: How do I calculate the subtotal for a calculated column using the subtotals of the other columns used in the calculation?

  • I 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.