List box Expression

[#1]

Hi all,

what to do if I want to add or delete values from list box for next customized report .For example see following Image,Here have to delete Connection Number,Meter Status and add Debit amount for next report.Can anyone help.

[anbu1984 · Accepted solution]

If you have loaded _Dimension through Inline load, then add dimension "Debit Amount" in Inline load

If you don't want to ignore few dimensions, then try like this

=If(Not Match(_Dimension ,'Connection Number','Meter Status'),_Dimension)

[#3]

Hi anbu,

It's showing like this, What to do?

[anbu1984]

You added above expression in expression tab. Remove that and add it in General tab. Select Field drop down in General tab and select last <Expression> and add the expression here.

[#5]

Thank you Anbu ,Its working...