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.
Add a comment