Show only cetrtain fields of a dimension

[#1]

Show only fields of a dimension that meet a certain condition, is it possible?

[ankit777]

u can add a calculated dimension with your conditions

[sunny_talwar]

Couple of ways you can handle it. As suggested you can use a calculated dimension with if statement and use suppress when null check box on dimensions tab with properties or you can use set analysis within your expression which restricts the dimension fields for only those which you want to see. Others will automatically removed.

HTH

Best,

Sunny

[#4]

Ok. Example:

My Dimension is AGENT

And I have an expression sum(sales)

I want ony show AGENT that accomplished this condition: sum(sales)>5

How can I do?

Thanks!!

[#5]

Hi,

One way to achieve is to use System Functions (ex;getselectedcount(),getfieldselections etc) depends on your requirement.

Regards,

Sridhar

[buzzy996]

Yes,it's 100% possible,u have to specify those conditions with expression or script whenever implementing.

[ankit777]

try using if(sum(Sales)>5,Agent) in calculated dimension

[#8 · Accepted solution]

Hi D,

you could do this with set analysis.

Sum({<AGENT={"=sum(sales)>5"}>} sales)

Joe

[#9]

Thank you but ERROR

[#10]

you'd need to adjust to

if(Aggr(sum(Sales)>5,Agent),Agent)

for a calculated dimension like this

Joe