Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi ,
how to change the settings for the values on data points to display each and every values for the pie chart.
Try something like this.
Suppose your Dimension is Region and your expression ist Spending:
1) in the expression tab Replace the expression sum(Spending) by
Dual(
Region & '-' &
Num(sum(Spending ), '#,##0') &
Repeat(chr(13)&chr(10), rank(Sum(Spending ))-6),
sum(Spending )
)
Select the Values on Data Points option.
On the Sort tab, select the Y-Value option with Descending direction.