How to filter out Project_No '9000098' from Project_Number

[bhaveshp90]

Hello,

I want to have all the Project Numbers except '9000098' from the Project_Number column.

How can  I do that? 

thanks

[sunny_talwar]

In the script or front end of the app?

[bhaveshp90]

In the front end. I have this bar graph but I want to filter this project Number from it. I am not using Project_Number as dimension or Expression here;

[sunny_talwar]

You must have some expression? Let's say your expression is Sum(Measure)... use set analysis to exclude the specific project

Sum({<Project_Number -= {'9000098'}>}Measure)

Alternatively, you can also use this

Sum({<Project_Number *= e({<Project_Number  = {'9000098'}>})>}Measure)

[dplr-rn]

Use this as part of your set analysis

Project_Number-={'9000098'}

[jayanttibhe]

in your Set expression  you need to Exclude this Proje Num - 9000098.

You can share your expression for exact solution.

[bhaveshp90]

When I used this expression. my chart is not displaying any data;

Sum({<Project_Number -= {'9000098'}>}((GMP_Gross_Profit_USD)/(GMP_Sales_USD)))*100

What am I doing wrong here?

[bhaveshp90]

I used this expression now;

Sum({<Project_Number -= {'9000098'}>}((GMP_Gross_Profit_USD)/(GMP_Sales_USD)))*100

My chart is showing no data

[sunny_talwar]

Don't see anything wrong with the expression... would you be able to share a sample or an image to see the issue?

[jayanttibhe · Accepted solution]

How abt this

(Sum({<Project_Number -= {'9000098'}>}GMP_Gross_Profit_USD)

/

Sum({<Project_Number -= {'9000098'}>}GMP_Sales_USD))*100