Top 10 For Specific Items

[pnn44794]

Hello:

This should be fairly simple, but I have to be missing something simple.    I have a straight table where I want to show the top tem items if they equal certain values.  I probably need 7 tables based on different values, but if someone can show me what I'm missing on one example, I can do the others.

Any ideas anyone?  As always, thanks in advance for any and all help.

[sunny_talwar]

It doesn't look and sound simple to me... at least without a sample... very difficult to say by just looking at a expression as to what you might be looking to get... Would you be able to share a sample?

[swuehl]

Maybe like this as single calculated dimension:

=Aggr(

     If(

           Rank(

                Sum(

{<project_include_in_forecast = {1},project_is_active = {1},
estimate_include_in_forecast={1},estimate_is_active ={1}, effective_item_action={'Add'} ,

catalog_item_class_tier2 = {'Microsoft SQL on PSI', 'Oracle on PSI', 'PSI Basic', 'PSI Basic High Density Disk'}

>}   

                effective_item_qty)

          ,3,1)

          <=10, project_id)

,project_id

)

[pnn44794]

Hello Stefan:

This did not work.

[pnn44794]

Good point Sunny and I should have thought of that.  I will post a data sample in a couple of minutes.

[swuehl]

Maybe remove the comma before effective_item_qty?

[pnn44794]

No luck with removing the comma.

[pnn44794]

Hello Sunny:

Ok.

[pnn44794]

Hello Stefan:

I did have one field wrong (triple checking the rest),where I renamed estimate_item_action to [Item Action], if that makes a difference.  I did change the calculated dimension to reflect the correct name with no luck.

[sunny_talwar]

Good start... not what is the expect output you expect to see from this data....numerical expected output