Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
@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