Expression to return list of values

[avastani]

What's the best way to return a list of values (non-numeric) in an expression.

I have Projects and Project Status. I'd like to have Project Status as dimension and the Projects falling in various stages as the expression and then color code the background based on their delay status.

There is no calendar in the app. It is a point in time for daily status.

[nagaiank]

You may create a pivot table chart with Project Status and Project as dimensions and delay status as expression.

[avastani]

No can’t do. I tried that. The visible chart object should look like

Phase1 Phase2 Phase3

ProjectA ProjectB ProjectD

ProjectC ProjectX

ProjectZ

With color codes for each project cased on their delay status in each phase

[swuehl]

Maybe like attached?

[avastani]

Yes, more so like attached but need to rid the Rowno() off the pivot though

[swuehl]

Then maybe using a straight table with a hidden dimension column and three expressions?

[avastani]

Yes, I had that as well, but the sad part is I have to encode every Phase in there and if there's new phases in the future, maintenance becomes a pain.

Pivot would have been ideal.

Interesting suggestion on how the autonumber(Project, Phase) brings it together. I know there's a way, just can't think of it right now. Brain freeze,

[rwunderlich · Accepted solution]

If you like the pivot but just want to hide the RowNo() column , how about just making the column invisible like the attached? (You can drag a column to about 1 pixel wide by dragging, I used a one-time macro to make it 0 pixels wide).

-Rob

[avastani]

that does the trick. Man o man what a day. Thanks Rob

[avastani]

Thanks to you swuehl for the rowno addition.