Problem with % expression in chart

[amber2000]

Hello everyone,

I'm strugling again with creating an expression in a chart.

I have 3 fields called Zone ,Tendu/Stock and Colli.

I want to see by Zone how may % is Tendu and how many % is Stock in a chart.

No clue what so ever on how I can manage this, can someone help me please, I've attached the QVW with the data.

Kind regards,

Monique

[#2]

Are you trying to see by zone what percent of the colli are stock or tendu?

[amber2000]

Yes that's what I'm trying to see but I want to see both Stock %  and Tendu %

Both accumulated should be 100%

[maxgro]

if you want this

- remove dimension Colli

- add expression  Sum(Colli) / sum(TOTAL <Zone> Colli)

and format in Number tab

if not, you probably have to play with the TOTAL

[Anonymous · Accepted solution]

See attached

[venkatg6759]

Check if this helps .

[#7]

Like this?

[alexpanjhc]

I hope this helps.

[amber2000]

Thank you so much, can you explain to me how the expression is working step by step please?

I don't just want to copy code but try to understand so I can manage these things myself.

Monique

[amber2000]

Yes this is very clear but I've seen a different way of expression that is not completly clear to me:

sum([Colli]) / Sum(TOTAL<Zone>Colli)