Grouping of Rows in a Query

29 Views

Hi Experts,

I have a requirement as follows:

100 User Group

A100 Users xxxx 100 ..... 50

A101 Users yyyy 100 ... 60

Total 110

50 Users Group

A50 Users zfdcfs 50 ..... 25

A50 Users adcga 50 .... 15

Total 45

20 Users Group

B20 Users hadcf 20

B20 Users sghdf 20

My problem is I have several Hierarchies for Users Group, but I can use none as they are grouped differently. Secondly I don't even have the indicator or anything in the InfoProvider to identify them as 100, 50, 20. My first question is - is there any way to create a different grouping at the reporting level and also generate total for each group ? My Second question is - I need to show 100, 50,20 in the report which is noway avaialble in the infoprovider, is it possible to create any contanst CKF or RKF, which I can use for display and also for calculation?

Thanks

Paromita

Message was edited by:

Paromita Das