[solved] Crosstab with Calculation aggregation issue

[cavalaxis]

I'm trying to use a calculated text value as a column header.  I'm having a strange aggregation issue.  Is what I'm trying to do even possible?

.	Calc1	Calc2	Calc3
label1	--	--	123
label2	--	456	--
label3	789	--	--
label4	--	--	--
label5	--	--	--
TOTAL	789	456	123

I've set the aggregation property in the model to automatic.  Help?

Thank you,
Lynn

[MFGF]

Hi Lynn,

I'm not clear what you're trying to achieve here.  Are you looking to reproduce the format included in your message, or are you getting that format but you require something different?

If you can give us some clear details about what you're trying to achieve, that would help.

Best regards,

MF.

[cavalaxis]

My apologies.  The result I displayed was not the result I wanted.

I fixed the problem at the Model level by adding the calculation to a passthrough query.   Thanks for your help anyway.