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
Put it all in a repeater... that might work...
i tried with repeater it does not work..
what doesn't work?
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?