Share of Total

[madmax88]

Hi all,

I have a question. I have following table

Customer	Product	Value
A	1	10
A	2	5
A	3	10
B	1	10
B	2	0
B	3	5
C	1	0
C	2	0
C	3	10

Goal is to find out the share of a product in a Portfolio of a customer. If I select Product 1, I want to know the share of product 1 to all products of each customer. In this case it would give me following results:

Dimension Selected: Product 1:

Customer	Share
A	40%
B	67%
C	0%

How should be the expression in set Analysis?

With my Expression I get only the share of a selected product to all products for each customer:

sum({$<criteria_1={'yes'}>}Value)/sum({$<criteria_1={'yes'}>}Total <Customer> Value)

In this Case I would become this:

A 50%

B 50%

C 0%

Thanks

[sunny_talwar]

Color? Where did the color came from? Are we talking about different issues or are we still working on the same problem?

[madmax88]

its another problem,but with the same expression. Shall i open a new thread?

[sunny_talwar]

Yes, I would think so... also, provide more details as this might not be enough to know what you are trying to do.