Forum Discussion

Fidzi8's avatar
Fidzi8
Helper V
6 years ago

% share in column

Hi, I would like to calculate %QTY share for haulier on the more destinations. First table shows %QTY when I filter the destination (from-to). Haulier CEMEX has 20,11%. Second table shows %Q...
Need Help
Tips and Tricks
az38's avatar
az38
Community Champion
6 years ago

Fidzi8 

so, what result do you need?

I see completely different logic in two pictures

  • Fidzi8's avatar
    Fidzi8
    Helper V
    6 years ago

    Hi,

    I will to try to describe my intention.

    When I filter table by Destination code - I will get % share Delivery quantity for Destination and Haulier ( CEMEX 20%)

    I want filter table by Haulier code (e.g. 4311) and I would see all destinations this haulier and real % share Delivery quantity.

    Now I see 7,24% but right is 2O,11%.

     

    Thank you
    Ondřej