Restrict and expression to a dimensional Value

[#1]

I would like to restrict and expression to a dimansional value. How can i do that.

Ex: I have Products and Amounts.

I would like to know, how much % is product is contributing?

[kaushiknsolanki]

Hi,

     All you need to do is create a chart with dimension as Product

     Expression as Sum(Amount)

     % Contribution expression as Sum(Amount) /Sum(Total Amount)

     Go to number tab and Click the % contribution expression label and click on Show in percentage.

Regards,

Kaushik Solanki

[#3]

Did not get that, can you please send me an example

[kaushiknsolanki]

Hi,

     You share your example and I will tell you how to get the output.

Regards,

Kaushik Solanki

[#5]

P1 - 100

P2 - 60

P3 - 40

the answer i am looking at is as :

%p1 - 50, %p2 - 30%,  p3 - 20%.

[#6]

Contribution : Net TurnOver - Total Cost

Contribution% : Contribution / Net TurnOver

regards-bika

[kaushiknsolanki]

Hi,

     Here is the application.

Regards,

Kaushik Solanki

[er_mohit · Accepted solution]

for this you have to use accumulation like

sum(Amount)/Sum(Total Amount)

and in number tab Fixed to 2 for this dimension and make sure Check on Show %

hope it helps