How to create a crosstab at this scenario?

[Anonymous]

hi ,

I need to create a crosstable I guess it is pivot table based on my requirement like

I have dimensions called 'Group_name', 'name', 'Date_selector', 'organisation'.

Once we select the group name we will get respective names like Contact Type, Name of school.etc;

so I need to display a table that shows like this based on the select of various organisations.

I am attaching the pic of 2 files.

Any help is highly appreciated.

[vinieme12 · Accepted solution]

Not sure what the problem is here!!

Create a pivot table and drag date_selector field above the expression, you will see a blue line indicating the position

A sample would help

[Anonymous]

Hi Pujari,

Thank you it worked how you explained.

But how to avoid Totals in Name as it is calculating for every group name which is not required.

~But wanted the total like in the previos First Pic where you can see Total at the bottom.

[vinieme12]

go to presentation tab and disable partial sums for "name" or "group_name" dimension and enable for MonthYear dimension

[Anonymous]

Thanks vineeth.

Perfect. Job done.