Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See attached
Are you trying to see by zone what percent of the colli are stock or tendu?
Yes that's what I'm trying to see but I want to see both Stock % and Tendu %
Both accumulated should be 100%
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
See attached
Check if this helps .
Like this?
I hope this helps.
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
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)