-
1. Re: LOD (Level of detail)/ "Set analysis"/ Calculated static value for the sheet
Zhouyi ZhangJun 19, 2018 6:01 AM (in response to james cronje)
Hi, James
Try this
{Fixed [Country],[Person]:sum([Sales $])}
/
{Fixed : sum([Sales $])}
Hope this helps
ZZ
-
2. Re: LOD (Level of detail)/ "Set analysis"/ Calculated static value for the sheet
Jim DehnerJun 19, 2018 6:03 AM (in response to james cronje)
1 of 1 people found this helpfulthis will do the calculation then you can filter or post by name, and country - you may want to add date to 2 LOD's if the data are daate dependent
{ FIXED [Customer Name],[country]:
sum([Sales])/sum(
{ FIXED :sum([Sales])})}
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
-
3. Re: LOD (Level of detail)/ "Set analysis"/ Calculated static value for the sheet
james cronje Jun 19, 2018 6:24 AM (in response to Zhouyi Zhang)Many thanks Zhouyi Zhang
So with the below I can now get Sales for John over Sales overall. If I want I can also add another filter for South Africa and I arrive at my desired figure, because we have included [Country] in the level of detail in the first part of the calculation.
Appreciate it!
-
4. Re: LOD (Level of detail)/ "Set analysis"/ Calculated static value for the sheet
Zhouyi ZhangJun 19, 2018 6:31 AM (in response to james cronje)
No worries, glad to help
ZZ