Question:
hello,
have a reprot with two charatcteristics - a and b
have two kf's - d and e%(calculated based on d)
need to show e% only for subtotal at a..
how can i do that.. when i do the calc for e now.. it shows on every line
in report.. i only want it show for the subtotal line at a..
is this doable?
Answer:
Yes, you can do it by positioning on characteristic b, mouse right click, suppress result rows --> always.
In this way you'll se only totals for characteristic a.
You have the opportunity also to make it in the query definition (right click--> properties-->suppress result rows)
Francesca
Answer:
i have already done that..
my question is.. the sytem is calcuating %d for all rows.. i want this
formula kf tobe only populated at the subtotal level.
Answer:
A calculated key figure works for every rows, so, also for totals and subtotals....
I keep on trying....
Answer:
You need VB coding to do that