Conditional Dimension or Expression

[#1]

Hi,

I need to show Product B & Stage 2 value 0 instead of 2. How should I do it in dimension or expression please.

Product	Stage 1	Stage 2	Stage 3	Total
A	5	2	4	11
B	1	2	3	6
C	7	8	6	21

[#2]

Ajay thanks but i can't download as I am restricted and using personal edition

[#3]

You can use this expression.

If(Product='B' and Stage2=2,0,Stage2)

Where Stage2 is an expression label.

[Anonymous]

As I understand you have an expression in Follow Up Docs and Returned Docs, that you want to have it as 0 if product=B, so why don't you keep your expression as it's and multiply it by *only(if(Product='B',0,1))

[Anonymous · Accepted solution]

As I understand you have an expression in Follow Up Docs and Returned Docs, that you want to have it as 0 if product=B, so why don't you keep your expression as it's and multiply it by *only(if(Product='B',0,1))