i need to mom comparision

[Swathi]

I need mom comparison in percentage.

i have create Line chart 

Line-Month

Measures

Sum({<MonthYear,Period,tkt_Year={'$(=Max([tkt_Year]))'}>} delv_qty)

Sum({<MonthYear,Period,tkt_Year={'$(=Max(tkt_Year)-1)'}>} delv_qty)

now i need the MOM comparision percentage

for ex (Feb2023 volume-Jan2023 Volume)/jan2023 Volume ((171.54-131.71)/131.71)*100, need percentage, beside the value, i need MOM percentage increase in brackets). Kindly help me how to do. it's little urgent.

[Parthiban]

Hi,

Try this one

MaxYear = ((Sum({<MonthYear,Period,tkt_Year={'$(=Max([tkt_Year]))'}>} delv_qty)
-
Above(Sum({<MonthYear,Period,tkt_Year={'$(=Max([tkt_Year]))'}>} delv_qty)))
/
Above(Sum({<MonthYear,Period,tkt_Year={'$(=Max([tkt_Year]))'}>} delv_qty)))*100

PrevYear = ((Sum({<MonthYear,Period,tkt_Year={'$(=Max(tkt_Year)-1)'}>} delv_qty)
-
Above(Sum({<MonthYear,Period,tkt_Year={'$(=Max(tkt_Year)-1)'}>} delv_qty)))
/
Above(Sum({<MonthYear,Period,tkt_Year={'$(=Max(tkt_Year)-1)'}>} delv_qty)))

Need to sort month in Load order. First check in table validate the output and then proceed the Line chart

[Swathi]

@Parthiban , Thanks for the reply, i have got output as expected,  the percentage i need to show in the same line chart.

it is two charts, i don't need two line charts, in same chart i have to give percentage in brackets beside value

for ex : 154.09k( MOM-0.7%) on each lable value or 154.09(-0.7%), Kindly chart should be same, percentage values should come in brackets in each label