none
Multiple Dimension values in column labels and calculated measure require using the total of one dimension value RRS feed

  • Question

  • Hi

    I've Pivot table created from SSAS cube as shown below where I am having one measure and two dimensions in column labels. I want to add a calculated column = Dimension3-Val1Total/Dimension-Val2.

    Please advise on how to achieve this.

    Measure 1              Columns Labels

                                  Dimension 3-Val1                                             Dimension 3-Val1  Total

                                  Dimension2-Val1             Dimension2-Val2

    Row Labels

    Dimension1

    Thanks

    • Edited by SQL2012BI Wednesday, July 8, 2015 5:07 AM
    Tuesday, July 7, 2015 8:44 AM

All replies

  • Hi,

    i request you to please explain your example in Adventure Works dimension and fact so we will provide you exact code.

    Regards,

    Manish

    Thursday, July 9, 2015 5:10 AM
  • Hi SQL2012BI,

    According to your description, we are still not clear about your requirement and the structure of your data. If you want to know how to add that calculated column. I think your can add a calculated member like:

    Aggregate([Dimension3].[All],[Measure].[measure])/[Dimension2].[Dim].currrentmember

    Please clarify a little more about your question with detail information and images.

    Regards,


    Simon Hou
    TechNet Community Support


    Sunday, July 12, 2015 6:50 PM
    Moderator