Hamed Hesham
New Member
Hi Everybody!
This is my first post, although I have been a silent observer for a very long time
So here is the issue. I have an extremely large dataset for customers (>1 million) in a text file. The data is structure so each individual customer sits in one row and the columns show variables (for ex. Revenues and Usage)
What I would like to do is group the customers in brackets (for ex. those whose revenues fall between 1-25, 25-50,50-200, 200-500, 500+). I know this can be done with pivot tables but the grouping is not customizable (i.e has to be in X units).
I would normally do this using a long IF statement in excel, but since this is not an option, is there a way to achieve this in Excel, Access or Business Objects?
This is my first post, although I have been a silent observer for a very long time
So here is the issue. I have an extremely large dataset for customers (>1 million) in a text file. The data is structure so each individual customer sits in one row and the columns show variables (for ex. Revenues and Usage)
What I would like to do is group the customers in brackets (for ex. those whose revenues fall between 1-25, 25-50,50-200, 200-500, 500+). I know this can be done with pivot tables but the grouping is not customizable (i.e has to be in X units).
I would normally do this using a long IF statement in excel, but since this is not an option, is there a way to achieve this in Excel, Access or Business Objects?
