Only show a specific value in Table chart.

[#1]

Hi,

I am trying to create a chart that only shows a specific value from a field.  For example a field "type" might have Declassified and Open.  How can i make it so that table chart only shows Open?  Is this possible without having to click in the field "Type."

Thank you for your help,

[erichshiino]

Hi,

You can use set analysis in all you expressions.

For example, if your expressions are sum( Value) and sum (Qtd)

The adjusted expressions are sum ( {<type={Open}>}  Value ) and sum ( {<type={Open}>}  Qtd)

Hope it helps,

Erich

[#3]

You could also specify an expression for your dimension in a straight table chart, i.e.

IF(Type='Open',Type)

Then select to Supress when it's Null

See attached.

[#4]

Thanks,

That works, but I still get these '-' marks that changes the table chart.  How can i get rid of those as well?

The first part works great.

[#5]

I clicked on supress null value and it worked to get rid of the '-'.    Can one add multiple variables. For instance, Type = open and color=red?

[#6 · Accepted solution]

Yes, you can supply additional conditions, for example:

IF(Type='Open' And Color='Red',Type)

[erichshiino]

Hi,

On set analysis you can also use multiple filters:

sum ( {<type={Open}, Color={Red}>}  Qtd)

or

sum ( {<type={Open}, Color={Red, Blue}>}  Qtd) -> meaning, type equals to Open and (Color equals to Red or Blue)

Regards,

Erich

[#8]

Thank you very much.  It is working great. 

Thank you Erich as well.  Your solution works as well.

Nicholas