Conditional changing measure value

[PRIT AMRIT]

I have a requirement and need your input.

As you could see the attached report print screen, I have a cross tab report with 4 dimensions & 1 measure. This report is based on relational package.
Requirement:


Could you please let me know if you have any logic in mind?

Thank you!

Regards,
Prit

[Lynn]

Your sample appears to be showing actual information about your employer/client -- I suggest you remove it from your post asap. Even if the numbers are not real it is not appropriate to share how a company approaches their analysis.

You can scratch out the actual product and customer names and replace them with generic labels so as to mask the specifics while still asking your question.

[bdbits]

Is this not a simple if/then/else or perhaps a case statement in the expression editor?
Or am I missing something?

[PRIT AMRIT]

Is this not a simple if/then/else or perhaps a case statement in the expression editor?
Or am I missing something?

Indeed it should do but haven't got it right yet...  :D

@ Lynn -- Thanks for your suggestion. I agree though the values are not real.

Cheers,
Prit