Skip to Content
0
Jul 10, 2007 at 11:27 AM

Only show subtotals (hide detail records)

42 Views

Hey,

I have a very special 'need'. I hope I can explain myself.

In short: I have a query and I only want to see the subtotals.

I have a DSO with the following relevant fields.

CITY, DATE, ORDERNR, CONSTANT, COUNT (= 1 for every order)

In my rows I add CITY and DATE

In my columns, I add

- KF: COUNT

- CKF: TOTAL --> SUMCT(COUNT)

- CKF: CALC --> COUNT/TOTAL*CONSTANT

CALC in words: The number of orders a day, divided by the total number of orders of a city, multiplied by a constant.

I want a report that shows for every CITY the cfk CALC.

So for every city the sum of CALC values.

So I want to lose the division by DATE. However, when I remove DATE from the rows, my TOTAL isn't right anymore. Beacause I need subtotals for every DATE, If i drop the date my TOTAL is the overall total.

So I was hoping there is a way to hide the detail lines, so that only my subtotals are visible. Something like the collapse of an ALV report.

Any other suggestions are appreciated.

Steven

Message was edited by:

Steven Dierick