Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
i have a pivot table which displayes project names , month and the count for each month by project.
i need month to be displyad as crosstab , so project should be horizontal , month should be vertical and the count has to be displyed for each month for that particular project.Some one said i have to move month to the top , i dont understand as already the column name month is on the top , how do i get values of the month to be on the top.
thanks
Hi, you need to drag & drop the column month (drag from it's title), to the top-right position, and see a blue arrow appears
Check this pic
Rgds