How to show value on only max and min dimension in chart?

[Anonymous]

I created a line chart with dimension "Period" and expression "sum({1} Sales)", and I want to show value on 2 data points, which Period of max Sales & min Sales.

Period:
LOAD * INLINE [
    PeriodID, Period
    1, 201301
    2, 201302
    3, 201303
    4, 201304
    5, 201305
    6, 201306
    7, 201307
    8, 201308
    9, 201309
    10,201310
    11,201311
    12,201312
];

Sales:
LOAD * INLINE [
Period, Sales
    201301, 23000
    201302, 34000
    201303, 45000
    201304, 12900
    201305, 32039
    201306, 35830
    201307, 39594
    201308, 20958
    201309, 20493
    201310, 40405
    201311, 30305
    201312, 93533
];

[swuehl · Accepted solution]

I've understood your request a little different, so here is my version attached.

Check the expression attribute expression 'Show Value' by clicking on the small + next to the expression label in chart properties - expression tab.

[Anonymous]

Thank you Swuehl, it is just what I want. And I can not understand why you put "total" into the expression, but it is right.

[swuehl]

You want to find the min / max Sales value across all dimension values, not limited to the current dimension. That's why you need TOTAL qualifier here.