CODEWITHSUNDEEP
excelpivotoffice365pivot-table
Omri Braha
Omri Braha

Reputation: 33

Pivot table without aggregation in excel

Given this table bellow:
enter image description here

In Excel,
when I insert a pivot table, the column 'id' has being calculated to a total sum
Clearly, it is not needed

Any thoughts of how can I remove the aggregation from this column alone and keep the same current appearance of the table ( same but without caculating id_1+id2...+idn)

Upvotes: 1

Views: 886

Answers (1)

Jos Woolley
Jos Woolley

Reputation: 9052

Create this measure:

MyID :=
VAR ThisName =
    MIN( Table1[Name] )
RETURN
    IF(
        HASONEVALUE( Table1[Name] ),
        CALCULATE( MIN( Table1[ID] ), Table1[Name] = ThisName ),
        BLANK()
    )

amending table/column names where required.

You can then drag this measure into the Pivot Table Values area.

Upvotes: 1

Related Questions