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

    creating Measure with Two Different Dimension

    ramesh konda



      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.



      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