Pivot table column name orientaion

[madhumitha]

Hello All,

I am trying to achieve the below orientation for my pivot table. Could you please help me with a work around?

I have pivoted 3 dims, month, week and date.

I need to show data alone in vertical orientation, where rest should be horizontal.

Thanks in advance.

[marcus_sommer]

It's not possible to mix a horizontal and vertical displaying within a single object. Maybe this is an workaround: Re: Vertical Data Text in Pivot Table whereby in your case I would just use the day() from your date because the month- and year-information is already displayed.

- Marcus

[madhumitha]

Thanks Marcus.