Dificult report

[Former Member]

Hi,

I have the following sales movements in a InfoCube:

(customer)(product group)(value)

X - A - 10

X - A - 5

X - B - 5

X - C - 1

Y - A - 2

Y - C - 1

Z - C - 1

I need to create a report below:

(product group) (number of customers) (billing value)

A - 2 (X,Y) - 24

B - 1 (X) - 21

C - 3 (X,Y,Z) - 25

My difficult is crate the column "billing value" because in this column enter only the value for the product group in the same line. Instead I need the total billing value for the customers.

thanks and regards

.

Edited by: carlo mosole on Oct 17, 2008 10:15 AM

[Former Member · Accepted solution]

Hi Carlo,

You can try as follows:

Give product group in rows.

In columns

i) create a new formula and define as constant 1 and give in 'aggregation tab' ref characteristic as 'customer' and

exception aggregation as 'counter for all values'.

ii)create 1 more formula and give key figure as 'value' and then in 'aggregation tab' ref characteristic as 'customer' and

exception aggregation as 'total'.

Hope it helps.

Regards,

Rathy

[Former Member · Accepted solution]

Hi Rathy,

thanks for your answer!

Your solution is valid also for release 3.5 ?

I dont find exception aggregation as 'total'.

Thanks a lot.

Carlo.

[Former Member · Accepted solution]

What i explained is for BI7 Carlo.

Regards,

Rathy