Skip to Content
0
Jan 10, 2008 at 04:13 PM

Realize Counter in Query without drill-down

38 Views

Hello to everybody,

I have got a query which is displaying POS data for different subsidiaries. In the rows is the subsidiary-number and the sales slip number. In the columns I have a counter as key figure, which shall count the number of existing sales slips. This works well, when I drill-down to the sales slip number and the correct number of sales slips is displayed as result at the last row of the key figure.

But I do not want every sales slip to be displayed, so I remove it from the drill-down, with the effect that the counter always shows "1" as result.

How can I make the counter work without having the sales slip in the drill-down?

Thank you very much!

PS: Sorry in advantage, if my English is bad, but I am from Germany.