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
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.
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.