Skip to Content
0
Former Member
Jan 02, 2008 at 10:46 PM

Ranges in Query

19 Views

Hi ,

I need to create a query - in the following format -

Diff Value >10 & < 15 >15 < 20 > 20 < 25 and so on

CCODE1 Cnfrqty 10 16 1

CCODE2 Cnfqty 30 14 19

To create such report - say if we have diff Value as a characterictic in the target ( on which the query is build ) - how can we use it to form such column ranges - we cannot have it as a key figure because if we do that - the diff gets aggregated while displaying at Ccode level .

Can someone let me know how to make such a query ?

Thanks