how to hide specific row in a Target field QV?

[chandu441]

Here I have created a Straight Table,

                              My requirement for the above table is, I would like to delete/hide a sepcific/multiple productName from the list shown above.

Please suggest me how to do this function.

And explain about only function with example?

[Agis-Kalogiannis · Accepted solution]

Hi Chandu

I'll start with the Only() function

The Only() function will return a value from a selected field, only if you have selected ONE SINGLE value from that field. If you select nothing or more than one values, it will just return null.

If you need to hide one or more values from your ProductName field in your example, you need to use Set Analysis in your expression. Something like:

sum({$<ProductName=-{'MoneyMarket SB'}>}[Sales Amount])

I hope this helps.

Regards

Agis

[Anonymous]

Hi Chandu

It looks like you have multiple ProductIDs for the same product. Is this right?

In your case using the ProductID as a dimension will cause this. I dont know your data but to me this seems at bit strange. It looks more like a row number. Could you verify?

[chandu441]

Thank you Agis