[ excel ] pivot table excel sub item to column

Changing pivot table from Compact form ( sub item ) to the tabular form ( column format )

excel_pivot_compact_form

compact form ( default )

 excel_pivot_tabular_form

tabular format

To do that 

Go to Design > Layout > Report Layout > Show in Tabular form

change_excel_pivot_table_from_compactform_to_tabular_form

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s