Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jm134
  • Order by date
  1. jm134

    InList Operator.

    That was it. Thanks a lot. You'd be surprised at how many folks ( including me ) didn't know how to do that. There has got to be another way to do though. I just doesn't make sense to have an InList or In operator if you can't accomplish something like the aforementioned issue. Thanks again...
  2. jm134

    InList Operator.

    Lets say I've got a report with a month demension, region demension and some kind of measure. I've got 12 months but I only want show the sum of three months ( doesn't matter which 3 months). I want to accomplish this using a formula not a filter. I was thinking I could use the InList operator...
  3. jm134

    Help!!!! Rank with a filter

    Try that nofilter with a break included on the brand??? That's my problem.
  4. jm134

    Help!!!! Rank with a filter

    Lets say I have 64 brands. I put a global filter on brand to just show 3 of them. So now I've narrowed my block of data down to 3 items. If I rank them as is,, they will be ranked 1-3. If I have no global filter I have 64 brands and if I use the rank commnad I will have 1-64. I want to use a...
  5. jm134

    Help!!!! Rank with a filter

    I've got a block of data that I want to filter down to 3 brand types using a global filter. But I want to rank the results against ALL the brands. I.E. if brand one is 64th overall but 2nd in the filtered list, I want 64 as the results. This is a hot one,, if someone has a solution, I'd love to...
  6. jm134

    Easy one????

    The scenario: I’m in designer. I’ve got 2 tables included in my Universe. They basically contain the exact same fields ( columns ) the major difference being the type of measure. The record data from table to table will very a little but the vast the majority of it will be the same. So...

Part and Inventory Search

Back
Top