3 Replies Latest reply: Nov 8, 2017 12:03 PM by ramesh konda RSS

    creating Measure with Two Different Dimension

    ramesh konda

      Hi

       

      I have a requirement where i have 3 Tables Fact, Country, Product (Store).

       

      in Fact Table i have a (Sales Measure).

      in Country Dimension i have to show the Top 10 Country with sales as below Measure.

      SUm({<Country={"=Rank(Sum(sales))<=10"}>}Sales)

       

      Now this is the issue where i'm facing to create a Metric like i need to show [ Count(Store) for Each Country ].

       

      The output should be like

       

         

      CountrySalesNo of Stores
      U.K$2,323,443 14
      U.S$6,755,890 32