Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Country | Sales | No of Stores |
U.K | $2,323,443 | 14 |
U.S | $6,755,890 | 32 |
This will give you count of stores for top 10 countries.
Count(Distinct {<Country={"=Rank(Sum(sales))<=10"}>}Product)
Hi
Please share your input and output data and please elaborate your requirement.
This will give you count of stores for top 10 countries.
Count(Distinct {<Country={"=Rank(Sum(sales))<=10"}>}Product)
Shraddha, Thanks for the Response.
didn't have time to look into this busy with other task, just now implemented Its working fine.