Skip to Content
0
Sep 06, 2013 at 01:54 AM

How to show subtotals and grand totals in suppressed row report

29 Views

Hi,

We got a requirement to suppress certain rows in CR. What we did is used below mentioned formula for key figure:

{FORMULA1}

If <Condition> then totext (keyfigure) else ""

As we are chaining the key figure, the new {FORMULA1} is not visible under Insert summery list.

  1. Is there a way to derive a new key figure with certain modification, which is visible under Insert Summery list? or
  2. Is it possible to create custom formula to calculate subtotal under each group footer?

Thanks,

Debjit