pivoting columns

[Srik]

Hi
I need to pivot columns i knew it can acheived if u have measures , but i need to pivot attribute values.

attached file consist of current layout and required layout.

thanks in advance.
kanth

[sir_jeroen]

Put it all in a repeater... that might work...

[Srik]

i tried with repeater it does not work..

[sir_jeroen]

what doesn't work?

[MDXpressor]

I am confused as to what you are attempting.  Your Required table doesn't seem to be a crosstab, and the data items don't seem to match.  I can tell you that the crosstab is going to aggregate whatever item you place into the measure section, be it Call Message or STD_ACTVTY.  In order to aggregate a text item it will simply perform a count.

Can you please clarify your issue for us?