Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
it doesn't work
no dates to show
Send Sample Data.
sum(SUMI)- sum(SUMRETURN)
Yearfield&': '&
num(aggr(((sum(SUMI)-sum(SUMRETURN))-Above((sum(SUMI)-sum(SUMRETURN))))/(sum(SUMI)-sum(SUMRETURN)),Yearfield),'##.## %')
It doesn't helped me... maybe my question wasn't correct, no data for show...
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,
thanks!
sample