Hi BOBJ Experts,
i need to categories based on measure value...measure values are not summarized.. ..the categories are small,medium,large..please find bellow sample data
s.no no amount quantity
1 10 2000 50
2 20 1400 25
3 30 3500 10
4 20 700 25
5 30 2700 12
6 10 500 43
7 10 5431 32
8 .....etc
i want to categories amount < 1500 then count(no),sum(amount),sum(quantity) that is small
amount between 1500 and 3000 then count(no),sum(amount),sum(quantity) that is medium
amount > 3000 then count(no),sum(amount),sum(quantity) that is large...
i want webi report like this..
count(No) sum( Amount) sum(Quantity)
Small Medium Large Small Medium Large Small Medium Large
3 2 2 2600 4700 8931 93 62 42
Etc..
i tried by using 3 objects...its working fine separately.....
At least guys to help count(no)....
when i`m creating webi count is same value i`m getting....bellow like this
count(No)
small medium large
12 12 12
can you guys give me a suggestion or solutions..please urgently required...