Bottom 3 but with a dimension condition

[cafcptg2011]

Hi,

I need to do a bottom 3 ranking but with one condition on my dimension, ie, i need to konw the bottom 3 region but with sales >0. I have attached qvw file to better understand my problem.

Could someone help me please on this.

Thanks in advance,

CAFC

[anbu1984]

Try this

[Gysbert_Wassenaar]

See attached qvw.

[mahesh_agrawal]

Hi,

Please find the attached QVW file.

I have shown 3 tables.

1. Shows normal ranking of all region

  2.Bottom 3 regions including regions having zero sales
  3..Bottom 3 regions excluding regions having zero sales(Final Output)

I hope it answers your problem.

[cafcptg2011]

Hi,

Thanks for your reply, it your solution works great! thanks for your help!

could you please explain me if i have one more variable, let's say orders, how can I do the same but if sales > 0 and orders >0 to filter the bottom 3.

thanks in advance,

your expression: sum({<Region={"=rank(-sum({<Sales={'>0'}>}Sales),4,1)<=$(vLimit)"}>}Sales)

[cafcptg2011]

thanks for your answer!