4 Replies Latest reply on Feb 11, 2019 8:52 PM by Shinichiro Murakami

    Alternative way of LOD. LOD doesn't allow data blending

    Shahroz Ahmed

      Hello Guys,

       

      I have using multiple data sources. I calculated total percentage for finding simple Total Percentage

       

      Sum(gci_fam)/sum(D2.BON18)

       

      so my result was correct.

       

      Now I want to calculate similar type of total percetange based on a dimension. Here I want to calculate total percentage based on Market

       

      so I used below formula:

       

      {Fixed ATTR([BO].[Market]) :  Sum(gci_fam)/sum(D2.BON18) }

       

      now I am getting error "Level of detail expression cannot contain table calculation or the ATTR Function"

       

      Please advise what are the other/alternative way to calculate if LOD is not possible with multiple data source?