on 11-29-2007 3:36 PM
Hi experts,
In one of my queries I am using the characteristics Plant and Order. I need to the count of the total number of orders for each particular plant. Does anyone know how to do this? For example:
Plant 1 | Order 1
Order 2
Order 3
TOTAL ORDERS 3
Plant 2 | Order 1
Order 2
TOTAL ORDERS 2
Plant 3 | etc....
Thanks!
CM
Hi,there are many workarounds to get this depending on your Query design and data.
Try this out: Create a new formula COUNT(keyfigure) .Set Calculate Result as 'Summation'.
So this column will restun number of Orders for a plant based on KeyFigure.
And Set 'Suppress result rows' to Never for Caracteristic 'Order'.
i assume that you only palant and order in rows as shown in your example.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you!!
Some of the values for my key figures are displayed as blanks - and thus are not counted - any workaround for that?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.