Difference in Crosstab

building reports webintelligence
1

Hi Guys

I have a issue coming in crosstab, hope anyone can help in this.

Salary is a fact coming from database min(salary), bonus is aggregated in universe is coming directly from db.

I have got data from Jan to till month, but when i am using previous function the very first month can’t give the exact difference which i want.

Year-Month combined at universe level and used as column title here in report.
I need to create report like i have in attachement.

Oracle DB, XI R2

Any input is highly appreciated !
Forum.xls (19.0 KB)

justdesi (BOB member since 2006-06-28)

2

Its a pity you are on XI R2, otherwise I would have sent you the webi document

Create crosstab
Insert break in crosstab
Create variable for month 1 : =Sum([Salary]) Where ([Month] = 1)
Create variable for month 2 : =Sum([Salary]) Where ([Month] = 2)
Subtract one from the other

You might want to replace month numbers with prompts?

jemstar :ireland: (BOB member since 2006-03-30)