Pivot table related query

[Anonymous]

Hi Experts

my dashboard o/p like this in pivot table is below

Type	Non Deal Management					Conference
Id	1X1	2X1	3X1	Conference	Group Meeting	1X1	2X1	3X1	Group Meeting

  After export to excel getting the below format

Type	Non Deal Management	Non Deal Management	Non Deal Management	Non Deal Management	Non Deal Management	Conference	Conference	Conference	Conference
Id	1X1	2X1	3X1	Conference	Group Meeting	1X1	2X1	3X1	Group Meeting

After export the excel ,i am expacted o/p like this.

Type	Non Deal Management					Conference
Id	1X1	2X1	3X1	Conference	Group Meeting	1X1	2X1	3X1	Group Meeting

How to get.......

Thanks

[shiveshsingh]

Like below

Conference	Non Deal Management	Type
1X1 2X1 3X1 Group Meeting	1X1 2X1 3X1 Conference Group Meeting	Id

I tried, got above result in table box

[ramasaisaksoft]

Hi Nani,

it won't happens like you mentioned.when i tried to export the pivot table i got properly only.

any way my suggestion is just create one more pivot table and export that pivot table with 2 modes

• Check this option ,Fully expand mode(For the First Dimension)
• Unchecked the option ,"Fully Expand (For the first Dimension)

export both the types of Pivot table and verify your result.

Example:-