Solve issue with not being able to group Pivottable from PowerPivot

Hi guys,
I badly need your help.
I have a PowerPivot table with more than one millions rows, and I need to group one of the numeric collums into numeric ranges, like [1-2], [2-4] etc. Normally this could easily be done with Pivottable, using Group and say "Start at, end at, ranges by". But now when the Pivottable is from PowerPivot, this function is not working.

So the questions is; How do I tell Excel that the numeric collum needs to be grouped by a predertimed ranges? I've read this could be done by some kind of relation mapping with another sheet, where the ranges is specified, but I cannot solve this. Or is it done by aggregation in the dataset?

I hope you guys can help me, it seems kind of sophisticated solution.

Best regards
/Daniel

Hi Romperstomper,

Thanks for your reply.

Yes, my bands should be the same size, but it doesn't mather to be hones. If it is easier one way or another. I just need them to be grouped in bands. If it is 1-2, 2-4, 4-10 etc, Its okay too, but preferably in the same bands.

What is your thought about this?

/Daniel