Key Figure Aggregation in Bex in BW 3.5

[KamalMehta]

Hi Experts ,

I have the Following Requirement for Upgrading an existing Bex Report.

2 New Key Figures need to be created . The Key Figures are % Lines Late and % Lines Not Late .They would be displaying the % age values.

The Requirement is as :

Defect Code Group   Defect Code    Lines               % Lines Late(NEW)     % Lines Not Late (NEW )

1                              A                   10                           (10/110)*100                100- ((10/110)*100 )

                                 B                   20                           ( 20/110)*100               100- ((20/110)*100 )

                                Result             30

2                              B                    50                            ( 50/110)*100               100- ((50/110)*100 )

                                 C                    10                           ( 10/110)*100               100- ((10/110)*100 )

                                 B                    20                             ( 20/110)*100              100- ((20/110)*100 )

                               Result               80

Overall Result                                  110

Kindly help and suggest to achieve the above .

Regards

Kamal

[former_member209202]

Hi,
You can achieve this defining structure in query designer and with cell referncing. Make sure your are using %A in formula of the query.  But i am really not sure how you are going to use Overalll result in your formula as it will updated dynamically evrytime withh different inputs to the query.

Regards
Sourav

[KamalMehta]

Hi Sourav ,

I need to do this based upon Overall result .

I can achieve the same using % GT Function but the as the reports is used in BO as well .That means check box " Allow External access has been ticked" and therefore the properties of  % GT function are not exportable so this cannot be used .

Regards

Kamal Mehta