Want to section my Crosstab report based on Fiscal week

[tarunkrdas2013]

Hi,

My requiremnt is i want to section my Crosstab report based on Fiscal week ,i dragged Fiscal week num as Crosstab Node member and tried to section Fiscal week Num but problem is when i try to create section on Fiscal week report studio says below message .Please note i don't wish to use Fiscal week in a List report and then Master - details with Cross tab as its slowing down overall performance of report

"Sectioning can be done only onList column ,crosstab node member,chartnode member or Visualization mode"


i have attached the report output currently i am getting and also expected output in screenshot please suggest me how i can section my report based on Fiscal week Num using Crosstab report

[tarunkrdas2013]

Just to update on this the message changed and it says Unable to create sections because no query item is associated with this object

But Fiscal week num is a data item itself

[tarunkrdas2013]

Please reply this needs to be solved

[bdbits]

You posted and expected an answer within the space of half an hour?

This is not a support site. People come here when they have time. No one is paid (including moderators, which is just fine) to wait for questions to pop up so they can answer them ASAP. It is just a place for like-minded people to help each other, if they so desire.

It looks like you had a text item selected (custom content in the cell?) when you tried to create the section. As the message indicates, you need to select a crosstab node member (assuming this is a crosstab).

[tarunkrdas2013]

Sincere Apologies i usually have patience but don't know why i got impatient this time,i truly agree