Show only a single value in a range of values

[#1]

Hi,

I have a field called "Project Stage" that can have 6 different values (say A-F for simplicity).

I have created 6 straight table charts, each titled A thru F.

I want the first table to just show projects in stage A, the second to just show projects in stage B, etc.

(Ideally, I'd rather have just one table with 6 columns, column 1 being projects in stage A, column 2 being projects in stage B, etc.)

I'm sure it's a simple expression, "project stage = "A", but I can't figure out how to write it.

Suggestions for the easiest way to accomplish this?

Thanks in advance.

[tresesco]

Take a pivot instead and drag the dimension rows to column.

[cfz]

Hi Daniel,

Please have a look to the attached example.

I hope it helps.

Carlos

[#4]

tresesco,

Thanks for the quick reply, but I'm not sure I communicated my needs sufficiently.

You suggest I create a Pivot table, and drag the dimension rows to the columns, but I really only have one dimension, that being "Project Stage".

if I have 10 projects (1 - 10) each has a project stage as follows:

1 A,  2 A, 3 B, 4 A, 5 C, 6 D, 7 E, 8 E, 9 F, 10 C

I want to end up with:

A     B     C    D     E     F

1      3     5     6      8     9

2             10           7

4

I'm not sure how I would drag the dimension row to a column???

[#5]

Carlos,

See my reply to tresesco above.

What you have provided looks very close to what I want.  I just seems like I will only get one row of results, whereas I'm looking for a table with 3 projects in column A, 1 projects in column B, 2 projects in column C, etc.