How to compare two dimensions with single measure in WEBI Report

[chanukya]

Hello All,

In BO WEBI report, based on two dimensions (Order ID, Contract ID) I need to show those line items only if Qty ordered (Measure) are different. Can anyone suggest on this.

Regards

Chanukya

[nscheaffer]

Can you provide some sample data, what you have tried, what is not working, what you expect, etc.?

[chanukya]

As per above screen shot, I need to compare Order ID (DIMENSION) & Product Code (DIMENSION) to show only different Qty ordered values along with list price in one table. In my example 3rd and 4rth line item are having different QTY ordered then we have to two only those 2 line items.

NOTE: All the columns are from same table.

[nscheaffer]

You need to provide enough detail so people here can help you. You say "all the columns are from the same table"? Do you have one query for both Order and Product data do you have two queries (one for Order data and another for Product data)? If you have two queries, how does the data connect? Which price do you want to show?

[chanukya]

Sorry for providing brief details.

You say "all the columns are from the same table"? Do you have one query for both Order and Product data - Columns I mentioned are from Single table. To showcase the data difference I did a split up of Order & Product data columns). Please let me know if anything else is required.

[nscheaffer]

What is confusing is that you have columns of the same name from the same table which cannot happen.

In any case, you just need to create a variable comparing the two values. Something like this...

=If([Order ID Qty Ordered]<>[Product Code Qty Ordered]; 1; 0)

Then create a filter to only show the rows that evaluate to 1.

[chanukya]

Thank you. This formula worked as per the requirement.