Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

grouping by range

Status
Not open for further replies.
smeyer56

smeyer56

IS-IT--Management
Joined
Oct 16, 2002
Messages
206
Location
US
CR8.5
Pervasive
Windows 2000
Is there a way to create a group selection based on a range
For example:
sales rep 1,2,3 in one group
sales rep 4,5,9 in another
and 6,7,8 in the last.
 
Sort by date Sort by votes
I have used formulas in these instances.

//@SalesGroup
if {table.SalesRep} in ["1","2","3"] then
"Sales Group 1"
else if {table.SalesRep} in ["4","5","9"] then
"Sales Group 2"
else if {table.SalesRep} in ["6","7","8"] then
"Sales Group 3"
else
"Sales Group X"

Click Insert->Group-> @SalesGroup


That's it
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

D
  • Locked
  • Question Question
Comparing two Date Ranges
Replies
0
Views
628
doodledump
D
PJ222
  • Locked
  • Question Question
is date within any date range in a dynamic array of date ranges
Replies
1
Views
446
PJ222
PJ222
socalvelo
  • Locked
  • Question Question
Date Range Formula - Data from two months ago only
Replies
4
Views
795
pmax9999
pmax9999
Insulations504
  • Locked
  • Question Question
why is my result getting multiplied by 17??
Replies
7
Views
710
pmax9999
pmax9999
jlr123
  • Locked
  • Question Question
date range group by month
Replies
8
Views
746
jlr123
jlr123

Part and Inventory Search

Sponsor

Back
Top