Reference lines and segments borders statically calculated

[googel84]

Hi everyone, I have a pivot table with just one dimension and I'd like to show for each of its value the percentage of sales target achievement both in number and graphically (with a linear gauge or a bar chart).

I also would like to be able to dynamically set different segments borders (in case of a linear gauge) or reference lines (in case of a bar chart) on each chart created (one for each dimension value) representing last fiscal year performance towards this year target. Numeric representation of this last number is correct whereas its position on the charts seems to be somehow globally calculated, as if the dimension would have just one value; i.e. the reference lines are set in the same manner for all the charts.

I also tried to create separate charts using calculated dimension but the result is the same.

Which could be the reason?

Thanks

[johnw · Accepted solution]

The problem is just what you think it is - segments and reference lines are globally calculated for gauges and I believe mini-charts. I know of no way around this. I'm not happy about it.