Skip to Content
0
Former Member
Nov 20, 2011 at 11:45 AM

Create a Categories Object....

22 Views

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...