Forum Discussion
Solved
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...
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
Your Pivot Table has to come from the Data Model. Not sure what you mean by not using Power Pivot, since by definition any measures must be created within Power Pivot.
Yes
can u post one solution?
can u post one solution?
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