Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
You may create a pivot table chart with Project Status and Project as dimensions and delay status as expression.
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
Maybe like attached?
Yes, more so like attached but need to rid the Rowno() off the pivot though
Then maybe using a straight table with a hidden dimension column and three expressions?
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,
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
that does the trick. Man o man what a day. Thanks Rob
Thanks to you swuehl for the rowno addition.