Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Something like attached
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?
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
)
Hello Stefan:
This did not work.
Good point Sunny and I should have thought of that. I will post a data sample in a couple of minutes.
Maybe remove the comma before effective_item_qty?
No luck with removing the comma.
Hello Sunny:
Ok.
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.
Good start... not what is the expect output you expect to see from this data....numerical expected output