YTD values in straight table

Wed, 25 Nov 2020 16:16:04 GMT

Hi experts ,

I have a requirement in my project where I have to divide the ytd values for 2 different KPI , PFB the explanation :

1)I have a KPI whose monthly values are like : Jan 100 , Feb 200 , March 300

2)I have another KPI whose monthly values are like : Jan 10 , Feb 20 , March 30

So if I take sum of these individual KPIs the calculation is like :

(100+200+300)/(10+20+30) =10

but I need it like this

100/10 + 200/20 + 300/30 = 30

I tried taking average of denominator but that scenario is not working and data is not matching upto 2 decimal places .

Can you please help in resolving this issue ?

sum({<{<month_num1={">=$(vMonth1)<=$(vMonth)"}>}Sales)

sum({<month_num1={">=$(vMonth1)<=$(vMonth)"}>} Volume))

vmonth1 =1 .

vMonth = month number for current month .

Re: YTD values in straight table

albertovarela — Thu, 22 Sep 2016 17:52:54 GMT

Use the Aggr function. Please see attached qvw