Where not equal to in Table chart

[psk180590]

Hello All,

I have a table with data as below

Product

AA

BB

CF

HG

Market

HG

IJ

KL

How do i select products where Product is NOT EQUAL to Market. My final result should be

Product

AA

BB

CF

HG

HG

IJ

KL

[psk180590]

I attached a mockup of my result here. Hope this is more clear.

The last two columns are the ones i'm looking to obtain.

[sunny_talwar]

You are trying to calculate Column H and I?

Do you already have the other things? Is this a pivot table? Can you share what you already have in a qvw file?

[psk180590]

Yes, i'm trying to calculate column H and I. Unfortunately i will not be able to share the qvw.

But, below are my formulas for the D, E and F

😧 sum({<Year={'2017'}>} Sales)

E: sum({<Year={'2016'}>} Sales)

F: Column(1)-Column(2)

Also, for Dimension Product i have a formula : =if(Product<>'Market',Product)

[psk180590]

The values might not be same for the excel i attached and when you load the test data with this formulas since i have lot more data in the same format

[sunny_talwar]

That is what is not helping me here. What you want is all 0's in the Excel file. Again we are back to where we were. You cannot share your own qvw, but can you update the one I posted? I will request you to take some time to do some work on your end before you expect me to come up with a solution.

If this is not possible, I would hope someone else might be able to help you better, because we are just going in circle when I am trying to help

Best,

Sunny

[psk180590]

did rework on your app and attached it.

Thanks!!

[sunny_talwar]

Check if the attached is what you wanted

[psk180590]

This is perfect but, is there any way we could avoid the 'TotalMarkt' under Product and it's corresponding values

[sunny_talwar · Accepted solution]

Check now

[psk180590]

Perfect man.

Thanks very much for your patience.

The way you think is something which i have a lot to learn from.