Using a calculated expression as a dimension

[nburton78]

Hello,

I'm working on a beast of a report.  Basically it takes a list of orders and then it assigns a reason based off the attributes that are pulled from all over the place.  I put everything in a Straight table and calculated the "Detail" column with an expression.  Now I would like to be able to chart those reasons listed in the "Detail" column and I have no idea if its possible.  I'd like to be able to count how many orders have each reason assigned.  Any ideas??

this is a very simplified version of the report:

order	attribute1	attribute 2	attribute 3	attribute 4	Detail
a	red	1	yes	10	Reason 1
b	blue	2	yes	9
c	green	3	yes	8
d	yellow	1	no	7
e	red	2	no	6
f	blue	3	no	5

The Detail is set by a formula that looks like "if(attribute1=red and attribute 2 = 3 then detail = Reason 1 else if….Reason 2…."

[vamsee]

If you use the same expression for Detail and create a calculated dimension, what is the error you have?

[nburton78]

that would be perfect except some of the attributes are expressions also.  I could move the expressions to calculated dimensions if I can I refer to a calculated dimension?

[vamsee]

Ohh..try that if you can. I would suggest the best way go ahead is to do your data modelling at the script level.

So, multiple residents and joins should so give you an aggregated table with the detail and attributes as fields.

If you can post you QVW with script & (sample or scrambled data, I can be more specific.