Forum Discussion

ChavdarG's avatar
ChavdarG
Frequent Visitor
5 years ago
Solved

Link Summary table to main data

Dear all,   Hope someone can help me find a solution to this one.   All customers are in a table called ALL CCs (all cost centres). Volume sales per item (SKU) are in a table called ALL Data PY-...
Need Help
  • ChavdarG's avatar
    ChavdarG
    5 years ago

    Ok, managed to fix it by myself. FYI I did the following change to the summary table:

     

    Summary by Brand by CC PY = SUMMARIZECOLUMNS('ALL Data PY-LE'[CCenter],'SKU Details'[Вид Търг.Марка име],"VOLUME PY",SUM('ALL Data PY-LE'[VOL BASE]))
     
    Now summarizing by cost centre from ALL Data PY-LE and not ALL CCs. Now it allows me to make a relationship b/n Summary by Brand by CC PY cost centre and ALL CCs cost centre. 
     
    And now it works.
     
    Best regards,
    Chavdar
ChavdarG's avatar
ChavdarG
Frequent Visitor
5 years ago

Ok, managed to fix it by myself. FYI I did the following change to the summary table:

 

Summary by Brand by CC PY = SUMMARIZECOLUMNS('ALL Data PY-LE'[CCenter],'SKU Details'[Вид Търг.Марка име],"VOLUME PY",SUM('ALL Data PY-LE'[VOL BASE]))
 
Now summarizing by cost centre from ALL Data PY-LE and not ALL CCs. Now it allows me to make a relationship b/n Summary by Brand by CC PY cost centre and ALL CCs cost centre. 
 
And now it works.
 
Best regards,
Chavdar