Different results in lines and columns

[SergioNogueira]

Hello,

I have this query where I wanted to have columns totals calculated as SUM and row totals calculated as AVG.

The query results I wanted are has shown below, but I am only able either to have SUM or AVG in rows and columns.

Month 1 Month 2 Total

Calculated KF Calculated KF Calculated KF Total

KeyFigure 1 3 2

KeyFigure 1 1 1

Total 2 4 3

Best regards,

Sérgio

[Former Member]

The possible solution is :

Bring your Keyfigure (for e.g. ) "X" in column.

Right click on it and hit Edit, then in Selection Bring in Time Char. Calendar Month .(Right click Calendar month and hit REstrict and select your Value 1.)

Repeat the same and thsi time while restricting select value 2

Now in Rows Bring in you selected Characteristics lets say A and B.

Now Hit on Row Structure and select New Formulae.

In that formulae you can put in the formulae of Average.

Hope this helps.

[former_member189638]

You can achieve this by using the cell definition

[Former Member]

Hi,

Welcome to SDN !!

If you r report has a fixed number of columns, you can create formula at the end and calculate the AVG manually. And leave the rows result as SUM.

Hope this helps...