Grouping Data That Does Not Exist In The Table(s)

Hi Anonymous - 

You could make a new Calculated Column in your table, which parses the portion of the string to group on. For example:

I think you are headed in the right direction with a separate table. You could do 2 tables, one for odd and one for even or a combined (see below). You then just need to create the relationship with your other table and then use the fields from the new table as your slicer(s).

Value     Category

001            Odd

002            Even

003            Odd

004            Even

I think jtownsend21 has a good start for your dimension table. Add as many descriptive attributes as you can think of, including the full code that is being parsed.

So yup....the answer is a combonation.

Just to follow up with what worked in it's entirety for the thread...

I found on the SharePoint where the data table exists of what all the possible options are and fetched that dataset as well.

In that table I parsed the field I needed parsed and grouped as I wanted.

Then I link the two tables together by the appropriate field and ka-boom! My reports show me what I was looking for.

Thanks to both of you guys for leading me down that path!! Awesome forum!