How to show each year as a column in list report

Cognos 8 Business Intelligence Report Studio
1

Hello All,

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

remcount
AmountRemit

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

thanks
asitta

2

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.