Set Anlysis for Dimension

[james]

Anyone have any luck using set analysis to derive a toggle? My situation is my Revenue total is derived from 4 sets of set anlsysis, yet I want the Dimension in a staright table to be smart ebnought to know that the First line should say gadgtes, the 2nd Line to say Widgets, the 3rd line to say Bolts and the 4th lione to say Nuts.

Any ideas?

[#2]

Not sure if I have correctly understood what you are trying to achieve but it sounds like you are trying to create a chart with a detatched dimension set. See if the attached is what you are trying to do.

[james]

Matt-  the issue is Dim1 should be based on like if(Color = 'Yellow', Gadgets,if(Fad = 'Old', Widgets))

Yet you cannot do an if than using 2 diff data sets.

So i was hoping i could use set analysis to give me the names

[Anonymous]

Matt,

a nice bit of code using data islands.

James,  do you have an example to post? 

[#5]

I've obviously not understood what you are trying to achieve. Can you explain in some more detail?