Skip to Content
avatar image
Former Member

Aggregation of percentage figure as key figure

Hello everybody, I need your help please!

I've create a new cube containing customerID and a percentage key figure representing the national part af a regional customer and bound it succsessfully to the reporting multicube.

I can calculate national/regional gross and net and any other key figure as percentage of the total of the respectiv key figure, and it works fine, but only as long as the customer is in the drill down.

If I want to see aggregate figures for regions, for instance, eliminating customer from drill down, it cumulates the percentages per region and calculates with this sums. The result ist catastrophic, since the sum of percentages per region is like 980%, for instance!!!

How can I bring about to sum the regional/national part and not the percentage key figure?

Thanks for any help

Alexander

PS I can provide screenshots descibing the problem

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Aug 21, 2007 at 12:19 PM

    use function %RT and %GT

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I've got it!

      The formula calculating percentage key figures must not contain restricted key figures. Othewise "before aggregation" will not be active!!!