Forum Discussion

Raph's avatar
Raph
Helper III
5 years ago
Solved

Use a dynamic distribution key

Hello   I would like to know how to build a chart where non allocated costs will be moved to countries based on their turnover weight. For example I have this :  Name Amount Analytic Reve...
Need Help
  • AlB's avatar
    AlB
    5 years ago

    Hi Raph 

    See the attached file for a possible solution.

     

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

  • AlB's avatar
    AlB
    5 years ago

    Raph 

    In fact, here is a simpler version without the auxiliary table. See the attached file

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

AlB's avatar
AlB
Community Champion
5 years ago

Hi Raph 

See the attached file for a possible solution.

 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers