How to show each year as a column in list report

Hello All,

in my list report (in cognos 8.3)
i am having


above both are measures

now i am having weighted average as (it is a insertable object)WeightAVG= total ([AmountRemit]*[remcount])/total([remcount])

i have year objects as 2008 and 2009 and 2010

in each year i am having below math

if ([remYear] = 2008) THEN ([WeightAVG]) else (null))

it gave me only one value (either 2008 or 2009 or 2010 value)

so i did as below

total (if ([remYear] = 2008) THEN ([WeightAVG]) else (null)))
it gave me irrelevent results

so how can i acheive it

please help me


I think you would have to create weighted average for each year in your query, i.e.:
WeightAVG_2008=total(case when [remYear]=2008 then [AmountRemit]*[remcount] else null end)/total(case when [remYear]=2008 then [remcount] else null end)

Hope this works.