Display only some information in a Line Chart but add information with filters when I want

[Manuel174102]

Hello everyone

So I have a line chart which is displaying information of 7 categories.

I only want to display at all times the information of two of them, but I want to be able to add the other categories when I want, through a filter. How could I do that?

The field name is Order Type, and the categories I want to show are Service and Delivery.

thanks

[Mark_Little · Accepted solution]

HI @Manuel174102 

I would use an if Statement.

IF(GetSelectedCount( Order Type]) = 0

SUM({<[Order Type}= {'1','2'}>}SALES),

SUM(SALES))

[Mario_De_Felipe]

You could use a variable to store the values you want to filter in the [Order Type] Field.

vOrderType = chr(39) & Concat([Order Type],chr(39) & ','& chr(39)) & chr(39)

And the expression in the line chart would be:

SUM({<[OrderType]={$(vOrderType),'Service ','Delivery'}>} Sales)

[Manuel174102]

thanks!