Question:
I want to create a report that only displays the results rows ( just totals) – is there a way to do this.
Answer:
Making use of Formulas may solve your problem.
You can capture Results values.
_________________
Truth alone triumphs.
Answer:
how would formulas help?
Answer:
Do you know about Formula Operator: SUMCT
_________________
Truth alone triumphs.
Answer:
formula operator sumct sounds very interesting:
If I have 3 columns:
Customer, Doc, True/False
1002, 1, 0
1003, 1,1
1004, 0, 1
__________
2, 2
I only want to see:
Result: 2,2
For this how would I use sumct
Answer:
I do not understand your requirement.
Are you looking for Restults or counting records?
_________________
Truth alone triumphs.
Answer:
SUMGT and SUMRT may also be considered for your requirement.
_________________
Truth alone triumphs.
Answer:
Here is a further explanation:
Customer, no of items, no of docs
1003, 2, 4
1003, 1, 5
1003, 2, 7
1003 result 5, 16
1002, 1, 2
1002, 2, 3
1002, 3, 1
1002 result 6, 6
I only want to see:
1003, 5, 16
1002, 6,6
thanks for your help.
Answer:
Make use of SUMCT.
Bye.
_________________
Truth alone triumphs.
Answer:
Try removing all drilldowns in the workbook
(I think you need to do this one characteristic at a time)
Answer:
I believe you can only achieve what you like with VB (it's not that hard... been there, done that).
cheers,
El Belgio
Answer:
Welcome back El Beglio!
What I am looking for is that as soon as I run the BW report - somehow either the VB code or a macro is invoked that will only give me the results rows.
Answer:
Hi!
I'm not quite sure I understand your problem...
The "obvious" solution is to use "customer" as the *only* characteristic in the query. Then there's exactly one line per customer in the report.
In case this is not a suitable solution for your problem: The VB exit "SAPBEXonRefresh" is called every time a query is executed. So you could fill your VB code into this sub routine. (Just press <Alt>+<F11> to get into the VB editor...)
Kind regards,
Christian