Applying pivot to get total value per name, but add items name only for unique

A) I have below data Name Value Item Robert 200 Apple Robert 500 Apple Robert 100 Orange Austin 50 Pie Austin 70 Grape Austin 20 Pie B) Want that, when a...

excel

JosWoolley
Feb 11, 2023
vt_excel

Create this measure within Power Pivot:

= CONCATENATEX( VALUES( Table1[Item] ), Table1[Item], ", " )

Change the table name as required.

You can then add this measure to the Values area of the Pivot Table together with the Name field (Rows area) and Value field (Values area).

Regards

vt_excel

Copper Contributor

Feb 11, 2023

Yes
can u post one solution?

JosWoolley

Iron Contributor

Feb 11, 2023

vt_excel

Create this measure within Power Pivot:

=
CONCATENATEX(
    VALUES( Table1[Item] ),
    Table1[Item],
    ", "
)

Change the table name as required.

You can then add this measure to the Values area of the Pivot Table together with the Name field (Rows area) and Value field (Values area).

Regards

Forum Discussion

Applying pivot to get total value per name, but add items name only for unique