Custom pie chart

[#1]

I have a pie showing various "error description".

I would like a pie with one specific error description vs all of the rest.

Shipment = 6

Design = 2

Supplier = 3

I would like to see for example shipment errors vs the rest ( pie with 6 , 5 )

Thanks !

[m_woolf · Accepted solution]

Try a calculated dimension:

=if(Field = 'Shipment',Field,'Rest')

or in script:

if(Field = 'Shipment',Field,'Rest') as Field1;

[#3]

Thanks , worked like a charm