Only show subtotals (hide detail records)

[steven_dierick]

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

[Former Member]

One way that we have done this in the past is to use a VBA macro to hide all rows where the value <> "Results", then hide the column that only shows "Result". You can use the Tools -> Macro -> Record New Macro function in Excel to get pretty close to the code needed for this.

Hope this helps...

Bob

[steven_dierick]

Hey Bob

Thanks for the answer.

It is indeed a solution for my problem, however I need a solution for a web report.

Thanks anyway ... (points rewarded).

Steven