Displaying the % in the column

[Former Member]

Hi BW Gurus,

Report Display

Keyfigures

Characterstics Actuals %income

(CurrentMon)

Intercompany Sales 3000 (3000/5500)(1)

Cigarate sales 2500 (2500/5500)(2)

Total Sales 5500 (1)+(2)

Guys as you can see the report layout,

My Problem is I Need to calculate the % income

I have two structures in the query & I can do cell values. But I caould not figure out how to calculate the values for % income.

Any help would be greatly apprecitaed as there is an urgency at the client

Thanks

[former_member188325]

hello,

have u got it?

[former_member188325]

hi,

1.create a dummy formula in rows structute .

provide description as "total sales" and fromuala as 1.

go to cell definition.

now double cilck on intersection points of Intercompany Sales-actauls and Cigarate sales-actuals.

right clcik on intersection point of actuals/total--)new formula.

Provide formula as Intercompany Sales-actauls+Cigarate sales-actuals.

Now total will return "Total sales".

2.Create one more dummy formula in KF structure "%income".

go to cell definition.

right click on intersection point of Intercompany Sales-%income -

---

>new formula

formula1: (Intercompany Sales-actauls)/ Total sales.

right click on right click on intersection point of Cigarate sales-%income---->new formula.

Formula2: (Cigarate sales-actuals)/total sales.

3.if u want u can for one more formula to calculate Formula1formula2 which gives total %income i.e always 100(for confirmation) by right clicking on intersection point of Total sales-%income--->new formula : formula1formula2.

Hope this helps.

[Former Member]

Hi,

The % should be total sales divided by individual sale amount......right. Then go for a RKF in which you can do the same restrictions and in the CKF use the RKF to calculate the total sales using SUM function. In the columns in the new formula you can get the % of what you want. Try out and get back. Hope this helps....