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




      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?