Salary Range in report

building reports webintelligence
1

Hi BOB,
some one could advise me. our requirement is count of salary by range in period of hiredate
The user will choose between dates i.e: The final report will looks like this way
Range---------No of employees
0-10,000----------- 16
10,001-20,000---- 118
20,001-30,000---- 120

30,000----------- 56
Any help will appreciated.
Thanks
Kitu

kittu11 (BOB member since 2010-03-02)

2

Create range variables as below

  1. Range_Var(Dim)
Range_var==If([Sal2]<=1000;"0-1000";If([Sal2] Between(1001;4000);"1001-4000";If([Sal2]Between(4001;10000);"4001-10000")))
  1. Count_Var(Mesure)

Count(Empno)

Add to report both variables

Rajubollas :india: (BOB member since 2009-09-04)

3

Hi Raju
Thanks your code works fine for me

Thanks
Kittu

kittu11 (BOB member since 2010-03-02)