Change percent between years

[QSense]

Hello

I have an expression shows historical data

and expression is :

Sum ({$<Servisler= {'Circuits'} >}Tutar) + Sum ({$<Servisler= {'CUTE (MDNS)'} >}Tutar) + Sum ({$<Servisler= {'IP VPN'} >}Tutar) + Sum ({$<Servisler= {'Managed Data Network Services'} >}Tutar)

+ Sum ({$<Servisler= {'Type B Services'} >}Tutar)

How can I make a line shows percentage of changes between years?

[#2]

HI

pls refer the attached file, I hope , This helps u.

Regards,

Kabilan K.

[QSense]

Hi

In my chart, There must be two expression one of them must be bar and other should be line

line should show changes between years as percent

I attach my example in SITA tab on the right side you will see chart

I put the changes percent in text box and they are on chart

[#4 · Accepted solution]

Hi,

change chart type as Combo chart.

and Add this as ur 2nd expr on your chart, column(1)/above(column(1))-1

and go to Axes tab- > select the 2nd expr and select right option in the position.

then go to number tab -> select the 2nd expr and select Fixed to as well as check the show in percent check box.

I Hope it will help You.....

[QSense]

Thanks ,

How can I show negative values above zero not under zero?

[#6]

try Split axes option in the axes tab..