-
1. Re: Default Mark Annotation for Country (Group)
lei.chen.0Nov 27, 2018 6:52 PM (in response to Sing Yan Ang)
Hello Sing Yan Ang,
I guess the point is set to the country with the largest area in the group.
A workaround is to use dual axis.
Sample workbook is attached.
Regards
Lei
-
Dual Axis.twbx 281.8 KB
-
-
2. Re: Default Mark Annotation for Country (Group)
Sing Yan Ang Nov 27, 2018 7:26 PM (in response to lei.chen.0) -
3. Re: Default Mark Annotation for Country (Group)
lei.chen.0Nov 27, 2018 8:07 PM (in response to Sing Yan Ang)
-
4. Re: Default Mark Annotation for Country (Group)
Sing Yan Ang Nov 27, 2018 8:59 PM (in response to lei.chen.0) -
5. Re: Default Mark Annotation for Country (Group)
lei.chen.0Nov 27, 2018 9:35 PM (in response to Sing Yan Ang)
Hello Sing Yan Ang,
In general, I think it is possible to solve this by a calculation (maybe using LOD).
Please attach a sample workbook for suggestions about the calculation.
Regards
Lei
-
6. Re: Default Mark Annotation for Country (Group)
Sing Yan Ang Nov 27, 2018 11:46 PM (in response to lei.chen.0)Hello Lei,
I did a LOD calculation: {FIXED Country (Group): SUM(Sales)}
But a problem with that is that this particular worksheet will not react to other worksheet filters when placed in the same dashboard. Hence, I decided to just stick with labels.
Thanks anyway!
Sing Yan
-
7. Re: Default Mark Annotation for Country (Group)
lei.chen.0Nov 28, 2018 5:28 PM (in response to Sing Yan Ang)
Hello Sing Yan Ang,
Please have a try at adding the filters into context.
Sing Yan Ang wrote:
But a problem with that is that this particular worksheet will not react to other worksheet filters when placed in the same dashboard.
Regards
Lei