Forum Discussion
Sunnarizing data
Dear all, I have a small problem which almost breaks my nerves (after 2 hours searching for a solution). I have a table which looks like this: ITEMNUMBER DESCRIPTION OURREF Status_orde...
Hi,
Drag columns1,2 and 4 to the Table visual and write this measure
=SUM(Data[Quantity])
Hope this helps.
Sorry, in the summary table, I do not need the "OURREF" column
Table = SUMMARIZECOLUMNS(Table1[ITEMNUMBER], Table1[DESCRIPTION], Table1[Status_order], "Quantity", SUM(Table1[Quantity]))
If I can assume that there is a slight mistake in your desired table (the extra 'Closed' status line)
