This content has been marked as final.
Show 4 replies
-
1. Re: Level metric - City, state and country level
Andrew Watson Apr 20, 2017 8:56 AM (in response to Dheeraj H)Look at using a FIXED formula. For example for State it could be:
SUM({FIXED [State]:SUM([Sales])}) / SUM({FIXED [State]:SUM([Sales])})
Brackets might be out of place but you should get the idea. You would do this for State and Country, don't think fixed would be required for City.
-
2. Re: Level metric - City, state and country level
Dheeraj H Apr 20, 2017 9:27 AM (in response to Andrew Watson)Thanks Andrew. I tried this and it should have worked for any other case.
But as my metric calculation has its numerator and denominator from two different data sources, it says level of detail expression does not support multiple data sources.
Is there any other alternative.
-
3. Re: Level metric - City, state and country level
Andrew Watson Apr 20, 2017 10:30 AM (in response to Dheeraj H)I'm away from my computer but post a packaged workbook and someone on the forum should be able to pick it up
Sent from Samsung Mobile
-
4. Re: Level metric - City, state and country level
Deepak Rai Apr 20, 2017 10:32 AM (in response to Dheeraj H)Hi Dheeraj,
Can you add mock data?
Thanks
Deepak