Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Group by Visual table

Hello, I have the below table which I have created based upon quite a few comuns in different tables. We want it to group by ddiD to only show 1 line and sums in-nm and in-nk.       thanks 
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi Anonymous,

    After research, your [in-nk], [in-nm] column come from another table which relate to your 'dairy' table indirectly. You need to transfer the value to the sample or one table related directly. I create calculated columns [nk1], [nm1], [nk2], [nm2], then use SUMMARIZE to create a new table to get expected result.



    Please download the file for more details.

    https://1drv.ms/u/s!Av62M_jYbMcegRTElJ2bPluGdYGP

    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi Anonymous,

After research, your [in-nk], [in-nm] column come from another table which relate to your 'dairy' table indirectly. You need to transfer the value to the sample or one table related directly. I create calculated columns [nk1], [nm1], [nk2], [nm2], then use SUMMARIZE to create a new table to get expected result.



Please download the file for more details.

https://1drv.ms/u/s!Av62M_jYbMcegRTElJ2bPluGdYGP

Best Regards,
Angelia