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.
Message was edited by: