How to filter the data in QS

[vinayvishwanath]

Hi All,

we have data in the below format and need to filter only few in them, kindly request to provide the solution for the same

Key

IT account

Mega process

Profit Center

Sales Organization

PPM

APM

Commonality level

Shared/Unique classification

Partner WBS Element

Paying Org

16909 AO

AO

BA

Business Adminstration (BA)

Y192

x

212G

#

16909

x

S

x

x

x

54

x

20319 AO

BA

BA

Business Adminstration (BA)

Y192

x

212G

#

16909

x

S

x

x

x

54

x

16887 AO

OP

BA

Business Adminstration (BA)

Y218

x

#

#

20319

x

S

x

x

x

54

x

16891 AO

CS

DCL

Deliver & Develop Customer Loyalty(DCL)

Y215

x

212G

#

16887

x

U

x

x

x

54

x

16930 AO

LK

DCL

Deliver & Develop Customer Loyalty(DCL)

Y215

x

212G

#

16887

x

U

x

x

x

54

x

16930 AO

GD

DCL

Deliver & Develop Customer Loyalty(DCL)

Y215

x

212G

#

16891

x

U

x

x

x

54

x

16930 AO

BN

DCL

Deliver & Develop Customer Loyalty(DCL)

Y215

x

212G

#

16891

x

U

x

x

x

54

x

16930 AO

MJ

DCL

Deliver & Develop Customer Loyalty(DCL)

Y215

x

212G

#

16930

x

U

x

x

x

54

x

I need to select on OP, CS and BN from the IT account

Thanks

Vinay

[YoussefBelloum]

Hi,

by filterring, you mean on a specific object ? using an expression for example ? or on the back-end (script)

[vinayvishwanath]

Hi Youssef,

In the above data, i am using IT account type as a dimension in bar chart, but i don't want all the objects to be part of it like out of AO, BA,OP,CS,LK,GD,BN,MJ.... I need only OP,CS and BN from the field. Please suggest which one would be better an expression in front end or in back end...(with expression )