Forum Discussion

Maureen's avatar
Maureen
Icon for Helper III rankHelper III
7 years ago
Solved

Group by with Related Tables

I have the two tables below and want to sum by product.  I have linked to the two tables by product id but the sum for product ID gives me the results in the third pictures.  I thought this will work seamlessly.  Do I actually have to create a new table just to aggregate by product when I have linked to another table showing product cost?  

 

Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Maureen 

     

    I would suggest you add a cost column with RELATED function as below.Then drag the cost column to table visual.

    Cost = RELATED(A[Cost])

    Regards,

    Cherie

     

1 Reply

  • v-cherch-msft's avatar
    v-cherch-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Maureen 

     

    I would suggest you add a cost column with RELATED function as below.Then drag the cost column to table visual.

    Cost = RELATED(A[Cost])

    Regards,

    Cherie