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.

[pnn44794]

I expect to see something like the following screenshot without having to filter for it.  Note this is filtered for 2017 Q4.  I also have 2018 Q1 to Q4 data, so with no filtering, I would expect top 10 for201704 to 201804 and then top 10 by each quarter when filtered.  Make sense?  In other words, an overall top 10 and then a top ten by quarter once you filter for a specific quarter.

[sunny_talwar · Accepted solution]

Something like attached

[pnn44794]

This appears to do the trick.  Thank you very much.  I will do some additional testing tomorrow morning and see if I can replicate the code (shouldn't be a problem) for other product categories and provide an update.

The use of *= is the first time I've seen that.  From what I'm reading about it, it specifies intersection or in other words give me just what matches what's in the { } for catalog_item_class_tier2 *=.  Is that right?

[sunny_talwar]

The use of *= is the first time I've seen that.  From what I'm reading about it, it specifies intersection or in other words give me just what matches what's in the { } for catalog_item_class_tier2 *=.  Is that right?

That is correct... I actually used it for my own testing not knowing if you needed it or not. In case you want to always show the specified catalog_item_class_tier2, then don't use the *. It is only when you need the intersection between your selection and what is specified within the set... you would need to use this....

[pnn44794]

Hello Sunny:

Sorry for the delay in replying.  I was able to successfully test today with your solution and I was able to tweak it for use with other similar scenarios (i.e. VSI, SAN, etc).  Thank you very much for your help..................again!!!  You're always great to work with and patient.  It's appreciated.

I'll mark your answer as correct.

On a side note, I also opened One To Many Problem - Multiple Fact Tables.  Not sure if you may have any insight into this or if you have time to take a look.  If not, perfectly understood.  Again, thank you for your help.

[pnn44794]

Stefan, thank you again for your reply.  It is helpful and I will mark it as such.  Thanks again.