Thanks for the update, I modified my query to use the GROUPING SETS feature instead which gives me a better count of all different field options individually (but not...

Thanks for your response

Just tried With Cube and works quite well. Just got to decide wether to requery the data set again for boththe 'with cube' operation and...

If we are using a very large data set then and each server has to support hundreds of concurrent users then the amount of memory required on the app server...