7 Replies Latest reply on Feb 1, 2018 11:20 PM by Calvin Pinto

# Create Grouping in a worksheet

Hi,

In the Image given below, I want to group the column named, count of orders placed such that the result comes out to be -

Count Of Order Placed     No Of Customers

1                                            6333

2                                             749

3-5                                          218

>5                                            28

• ###### 1. Re: Create Grouping in a worksheet

Hi Calvin,

Please Create a Calculated field, copy and paste following calculation into it and Name the Calculation. Then Drag and Drop newely created calculation into view and enjoy

IF COUNT([Orders Placed])=1 THEN "1"

ELSEIF COUNT([Orders Placed]) = 2 THEN "2"

ELSEIF COUNT([Orders Placed]) >=3 AND COUNT([Customer ID]) <=5 THEN "3-5"

ELSEIF COUNT([Orders Placed]) > 5 THEN ">5"

END

Please mark this as correct answer and mark it as helping one so that other people can use this solution in future.

Regards

Raja Usman Ali

• ###### 2. Re: Create Grouping in a worksheet

Hi Usman,

Number of customers is a table calculation with specific dimension named actual user Id, when using the calculated field suggested by you, it gives the following -

Count of orders placed     Number of customers

1                                               7238

2                                               blank

3-5                                            blank

>5                                             blank

• ###### 3. Re: Create Grouping in a worksheet

Please Share full screen Shot so i can check Number of Customers pill

Regards

Raja Usman

• ###### 4. Re: Create Grouping in a worksheet

Hi Usmaan,

If I remove the Count of Order placed, it results into this:

• ###### 5. Re: Create Grouping in a worksheet

Hi Calvin

see the attached

then count the customers to return this

'

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

• ###### 6. Re: Create Grouping in a worksheet

HI Calvin,

I am looking that the green pill showing Number of Customers is actually a table calculation. Please share this calculation and remove other two blue pills from details. Further more let me know is there any unique key for identification of customers ? If YES, then it will be more easy without Table Calculation.

Regards

Raja Usman Ali

• ###### 7. Re: Create Grouping in a worksheet

Hey Usman,

Thanks, the above suggestion worked for me!