Filter output in pivot chart

[#1]

Dear,

I have a pivot chart with dimension 'Invoice_Status' which has value 'Invoice Closed' & 'invoice rejected' and I want to display only 'Invoice closed' data, than how to i do that

[kaushiknsolanki · Accepted solution]

Hi,

   Try this.

   if(Invoice_Status =  'Invoice Closed',Invoice_Status)

   Also check the suppress when value is null.

Regards,

Kaushik Solanki