I figured it out. I added a case expression in my sql and then added it to my query in SSRS.

(case when c.desc2 like '%exchange trade%' then 'ETF 13F'...

Great. This works. Now I have the issue of how to sort. I tried sorting within the category group properties using A to Z. Is there...

Here's how I got this to work...

Select isnull(AAA,0) + isnull(BBB,0) + isnull(CCC,0) as Original

from MY Table

Thanks for your help.

This doesn't seem to be working.

What I have is 3 columns and each have numeric numbers. I need to sum them up into one new column called amount. ...

I'm not sure how to write the query. Being that I'm a beginner with SQL I need some help. I tried using my table and I'm getting an...

Ok, this will work, but I have 6,479 rows and it will increase. Do I do the Union ALL Select 6,479 times?

Hi KL25, In the example you provided above, is there a way to also pull in the dimensional table names on the same query?

Thanks,

Thanks for your reply.

I ended up going with the following select statment and it works well. It gives me all the dimension keys for all the fact tables.

SELECT t.name...