This content has been marked as final. Show 3 replies
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
|Country||Sales||No of Stores|