Creating query depending dimension 's LOV

Post Author: Ferhat

CA Forum: WebIntelligence Reporting

hi..

i 've got a problem with creating a report like that:

i ve got a year and month dimension objects and sales measure object. İn year object i've got 1998, 1999 and 2000 datas.

i want to do add column that doing this:

for 1999( for april : ( (sales in 1999 april - sales in 1998 april) / (sales in 1998 april))

for may : ( (sales in 1999 may - sales in 1998 mayl) / (sales in 1998 may)) ...)

and

for 2000( for april : ( (sales in 2000 april - sales in 1999 april) / (sales in 1999 april))

for may : ( (sales in 2000 may - sales in 1999 mayl) / (sales in 1999 may)) ...)

how can i do this in web intelligence..i need help

tanks a lot...