New Calculated row in report output

[Former Member]

Hi Experts,

We have a requirement to add a new row after the default result rows, which will perform additional calculations. Can you please let me know if this is possible? I cannot use structures as the report format is not fixed.

Materail Grp Material Sales Inv GIV

G1 M1 xxxxx xxxxx

M2 xxxxx xxxxx

Result row xxxxx xxxxx

Calculated Row yyyyy yyyyy

G2 M1 xxxxxx xxxxx

Resutl row xxxxx xxxxx

Calculated Row yyyyy yyyyy

We are working on BI7.0 version.

Best Regards,

Rachandr

[Former Member]

Hi,

The content of the calculated row includes both the results row as well as the calculated row values.

This report is related to Price and Margin Analysis, if you need I can send you the sample format prepared in excel file.

Best Regards,

Rachandr

[Former Member]

We are working on BI7.0 version.

[Former Member]

What is the content of the calculated row? Is it depending on the results that are fetched above?

[Former Member]

Hello,

What BI version are you using? Are your users using BeX Analyzer? If yes, you can write a VBA code to compute and add the additional rows after the user has refreshed a query.

[Former Member]

This is not possible.