Count-Bucket wise format

[dhanu_today]

Hi Everyone,

I have the fields like ID,SAL,DIRECTION.

I have to show the DIRECTION as Dimension , sum(sal) by direction wise,The Count(ID) based on the SAL range.

DIRECTION	SAL	Count(ID)	SAL<=0	SAL>0 AND SAL<=10000	SAL>10000 AND SAL<=20000	SAL>20000 AND SAL<=50000	SAL>=50000 AND SAL<=100000	SAL>=100000
S	215836	7	1	5		1
N	453625	6	1	2	1	1	1
E	480959	7	1	3	1	1		1
W	672249	4			1	1	1	1

Please find the attached sample data and the output format as well.The logic development in design level is an added advantage.

Thanks in adv,

Dhanu

[maxgro]

hope it helps

[MK_QSL · Accepted solution]

Let me try also....

[#4]

Hello Dhanu,

1. are your ranges disjunctive?

I looked on your sample report and you have for example:

>=5000 in one range, and <= 5000 in another one, so if sale=5000 it should be showed in both ranges????

2. Is number of this ranges and boundaries static or maybe you would like to load it from some external source?

regards

Darek

[dhanu_today]

Thanks Manish and Massimo its working.

Dariusz - The Data is may be typo mistake.

Dhanu

[MK_QSL]

Hi,

Kind request you to make correct answer for those who have replied earlier and helpful to others.

This would be the true justice for his/her work.

This will encourage members to reply !

Thanks ....