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

[surendraj]

In script

where Not match(Product,'Market')

[surendraj]

Or

where Not wildmatch(Product,'*Market*');

[sunny_talwar]

Or this

Where Product <> 'Market';

[psk180590]

Hello stalwar1‌ and surendraj‌

Product      Revenue

AA               100

BB               100

CF                100

HG               100

Market          1000

IJ                    180

KL                    150

out of this data i would need to display a table chart as follows

Product          MarketShare

AA                        10%

BB                         10%

CF                         10%

HG                         10%

IJ                              18%

KL                              15%

[sunny_talwar]

May be like this:

Sum({<Product -= {'Market'}>}Revenue)/Sum(TOTAL {<Product = {'Market'}>}Revenue)

[psk180590]

stalwar1 Thanks for the quick suggestion.

But, in the Product column i would need to display only the Products without Market and this would be as a dimension.

[sunny_talwar]

That is exactly what my expression is going to do.

Dimension

Product

Expression

Sum({<Product -= {'Market'}>}Revenue)/Sum(TOTAL {<Product = {'Market'}>}Revenue)

[psk180590]

I'm not sure but this formula doesn't work for me.

It calculates all the products and shows the total sum for each.

So, in this example it gives me 73%(730/1000) against each product.

[sunny_talwar]

Don't know, but this is working for me