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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.