Hi Tina

In a PT, the grouping bucket must be the same size.

The bucket you wanted for 10-59 is 50 while 60-99 is 40, so it will not work in a PT.

Hope this explanation is clear enough.

Sunny

Thanks! but why does it not grouping like,

10-60

61-111

? many thanks? 

Hi Tina

10-60 and 61-111 is a bucket of 51, not 50

60-10+1=51

111-61+1=51

I suggest you post a file with sample data and your expected result.

It will be easier for us to understand what you need.

Sunny

hello Sunny,

thanks so much for the reply! 

I attached a sample file and pivot table, the grouping is not what I need,

appreciated with your input!

Tina

Hi Tina

It looks like the values with decimal place (34.5, 1999.95 etc) is the cause of your problem.

Try rounding them to the nearest whole number. It will give you the result you are looking for.

Hope this helps.

Sunny

hi Sunny,

I tried your suggestion, but the result was not changed. 

thanks,

T

Did you refresh the Pivottable?