Exclude records

[JoseGarcia]

Hi there, 

Can anyone assist with the following?

Is it possible to exclude all records from Dimension: Status that contain CLOSED from all dashboard kpi objects?

I thought I could add an expression to sheet properties with the data limitation.

I cannot add limitation by the script as I may need CLOSED records for another sheet.

As always, thanks a million for your support! 

Regards

Jose

[Vegar · Accepted solution]

You can exclude the Status CLOSED transactions in the expressions used in your dashboard by using set analysis.

Let's say you have an expression SUM(Amount) then you would need to extend that expression with a SET excluding Status CLOSED, like this. 

SUM({<Status={'CLOSED'} >} Amount)

I hope this could be of help for you . 

[JoseGarcia]

Vegar , 
Many thanks for you reply.

This mean I have apply set analysis expression to every KPI object. 

A bit long winded, but It works! 

Rgards

jose