Exclude selection in chart dimension

[sifatnabil]

Hi,

How can I show all values of a field in the straight table chart dimension even if specific values of that dimension field are selected? It would be like set analysis in the dimension, where I want to exclude the field Market, i.e. <Market=,>

[tresesco]

Say you have Market as Dimension, Expression=Sum(Sales). Now you re-write your expression like: =Sum({<Market=>}Sales)

Your dimension values would not respond to Market selection; you would see all Markets even one is selected.

[sifatnabil]

Thanks. As this is a straight table, instead of summing, I want to list out all the values while excluding Market. So the expression I tried is this:

=({<Market=>} FieldName)

But this is a syntax error. Is there a way to exclude Market in this expression?

[varunjain]

For the above scenario, try the below expression

=Sum({1}Sales)

[tresesco · Accepted solution]

Try like:

=Concat({<Market=>} Distinct FieldName, ',')

Note: Distinct is your choice/requirement

[ashfaq_haseeb]

Hi

Write below expression

=Sum({<Market=>}Sales)

And go to presentation tab and hide your expression. hide expression.

Regards

ASHFAQ

[varunjain]

If you want that nothing should change the straight table then try =sum({1} FieldName) instead of =sum({<Market=>} FieldName)