Create new table within existing dashboard with more filters

[ngreddy1982]

Hi ,I have a dashboard from which I am trying to get table with in a sheet. 

Three columns

1.SKU id (all needed)

2.Product type (only Standard - see pic)

3.Brand - (have to exclude CHANEL brand)

how can I do this.. is this possible?

[kaushiknsolanki]

Hi,

Yes it is possible.

If you need it with selection then all you need is the last selection which is Brand excluding the Chanel.

Select the Chanel and then right click on the listbox where you will find the option, select excluded, once you do that all values except the Chanel will be selected. And you are done.

Otherway is use the set analysis.

Create a chart with straight table type.

Add all the dimensions then create expression as below.

Sum({<SKU = {"*"},Product = {"Standard"},Brand-={"Chanel"}>}1)

Then go to presentation tab and select the expression and click on hide column. Click Apply and you are done.

Regards,

Kaushik Solanki

[ngreddy1982]

Thank you, i will try that this afternoon and let you know.