chart

[denis115]

Hello ! Help please,I have a chart and I need to have numbers in percentage above each year. I select  year 2016 and 2017 and in chart I need to see difference beetwen this years in percentage, how can I do this?

Thank you!

[denis115]

it doesn't work

no dates to show

[pathiqvd]

Send Sample Data.

[denis115]

sum(SUMI)- sum(SUMRETURN)

[pathiqvd]

Yearfield&': '&

num(aggr(((sum(SUMI)-sum(SUMRETURN))-Above((sum(SUMI)-sum(SUMRETURN))))/(sum(SUMI)-sum(SUMRETURN)),Yearfield),'##.## %')

[denis115]

It doesn't helped me... maybe my question wasn't correct, no data for show... 

[denis115]

[pathiqvd · Accepted solution]

Hi,

Example:-

Sales:

load * Inline [

Yearr,SUMI,SUMRETURN

2015,400,200

2016,200,300

2017,700,600

];

Dim:-

=Yearr&': '&

num(aggr(((sum(SUMI)-sum(SUMRETURN)) -above((sum(SUMI)-sum(SUMRETURN))))/(sum(SUMI)-sum(SUMRETURN)),Yearr),'##.## %')

--> Mean(2016-2015/2016)....

Expr:-

=sum(SUMI)-sum(SUMRETURN)

Regards,

[denis115]

thanks!

[denis115]

sample