Question:
Hi all,
Is it possible to suppress all rows in workbook except for the result row in 2.0B.?
I've heard that it is possible in 3.0.
Any help or hints on how to solve this in 2.0 are greatly appreciated!
Answer:
You could do it with VB for Excel... I did it
Cheers,
El Belgio
Answer:
Thanks, but will that work for webreporting without being too complicated?
Answer:
No clue... we're not using Web reporting for now. I guess you could do the same with some Java programming?
Answer:
just a guess,
did you try with right click and display as "no display" for all characteristics ?
Answer:
that still gives lines on the detail specified in the original query... it just doesn't show the characteristics values anymore
Answer:
Yes, I've done that. It does not work.
BR
Answer:
Hello,
Please disregard my answer is it does not make sense.
I think that if you create an hierarchy with only a Total or Result node and include the range of the Infoobject in the node and then, on the query builder, define the correct display level of hierarchy for the characteristic that is using the hierarchy you will achieve what you want!!
EF
Answer:
Yes, thanks, I think that could work. Unfortunately not in our case since we have an aggregation that affecs a lot of characteristics which we need to have a drilldown on in the reports in order to get the aggregation correct.
BR
Answer:
Try removing the drill-down on all cahracteristics except for the highest level. Can do this in workbook, or in query definition by moving all but the highest level characteristic to the free characteristic section.