Forum Discussion

Julier's avatar
Julier
Helper III
2 years ago

LINE AND STACKED COLUMN CHART

Im trying to create this visual, however the S&OP figure is a changing figure each month but it will only show it as a sum, it wont let me show it without summing it, the data is in 2 tables, i have ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Julier ,
If you want to display values in different tables without summing. You need to establish a relationship between the two tables.
Sample data
Monthly Sales

S&OP


Relationship


Final output



Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

  • Julier's avatar
    Julier
    Helper III
    2 years ago

    Thank you, howver i am unable to get a one to one relationship 

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Julier ,

      Thank you for your reply, the issue is due to the fact that you have duplicates in your data and the model is unable to create a relationship on that. You can create relationships with non-duplicated primary keys, for example you can create relationships based on event ids (non-duplicated)

      Best regards,
      Albert He

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

      • Julier's avatar
        Julier
        Helper III
        2 years ago

        Thank you, i have had to total my daily sales into a monthly figure using a measure and plotted this into the graph, the S&OP figure is a also monthly figure but i cannot link these, i have provided the sample data which i have then amended in the query to give me these two tables which i cannot build any workable relationship 

        The first table is the sample S&OP and the second table is the sample sales by day which i have then totalled using a measure.

        SiteClusterERP ID*Customer NameCustomer GroupNew CategoryM2S ClassificationFM IDMay-24Jun-24Jul-24
        northNorth3219/0aaaaaaaaaaaaaaxx                                               8,205                                        8,000                                        8,000
        northNorth1963/0bbbbbbbbbbbbyy                                               7,907                                        7,907                                      10,900
        north westNorth600070ccccccccccccccxx                                             26,130                                      31,816                                      16,784
        north westNorth600006ddddddddddxx                                             67,000                                      67,000                                      76,000
        north westNorth600002eeeeeeeeeezz                                             45,000                                      45,000                                      55,000
        north westNorth600001ffffffffffffffxx                                             32,000                                      32,500                                        8,238
        north westNorth600082ggggggggggxx                                           450,000                                    450,000                                    400,000
        southNorth600015hhhhhhhhhhyy                                             48,620                                      44,453                                      48,660
        southNorth600054iiiiiiiiiiiiiiiiiiyy                                           250,000                                    250,000                                    200,000
        southNorth600073jjjjjjjjjjjjjjjjxx                                           380,000                                    385,000                                    400,000
        southNorth17316/0kkkkkkkkkkxx                                           310,000                                    400,000                                        5,000
        southNorth3219/0llllllll.llllllll.zz                                             45,500                                      40,470                                      55,617
        Plant NameCustomerPlant Customer ERP IDShip To Customer Id ERPProduct CodeVolume (SQM)Selling PlantShip-To Customer NameDate ShortCalendar Month NameCalendar Year
        northaaaaaaa3219/0  905 aaaaaaa18/05/2024May2024
        northbbbbbb14667/0  1,599 bbbbbb19/05/2024May2024
        north westccccccc14667/0  1,936 ccccccc20/04/2024April2024
        north westddddd14667/0  2,570 ddddd21/06/2024June2024
        north westeeeee14667/0  6,746 eeeee22/05/2024May2024
        north westfffffff14667/0  1,002 fffffff23/04/2024April2024
        north westggggg14667/0  4,724 ggggg24/05/2024May2024
        southhhhhh14667/0  944 hhhhh25/05/2024May2024
        southiiiiiiiii14667/0  3,488 iiiiiiiii26/04/2024April2024
        southjjjjjjjj1968/0  3,171 jjjjjjjj27/05/2024May2024
        southkkkkk1968/0  8,262 kkkkk28/06/2024June2024
        southllllllll.1968/0  4,721 llllllll.29/05/2024May2024