Pivot : Group Data Problem

**Jhon Mustofa** · 10-08-2015, 12:58 AM

hi all..

how to group by quarter data if the date in header

please, check out my file..

any help me, much appreciated,...

john m

**stasinek** · 10-08-2015, 02:04 AM

My suggestion in the appendix. You need to change the layout of data

**Jhon Mustofa** · 10-08-2015, 02:17 AM

thank but not my suppose..any other idea?

**stasinek** · 10-08-2015, 02:45 AM

Other solution. PT created using the wizard, and an option - many scopes of consolidation. Months are pogrupwane hand and then transferred to the column labels

**Jhon Mustofa** · 10-08-2015, 03:49 AM

hi stasinek, how to show Q1, Q2, etc..
how make formula it?

**stasinek** · 10-08-2015, 04:17 AM

See step by step: https://youtu.be/lu1luOtfvXY

**Jhon Mustofa** · 10-08-2015, 04:46 AM

Originally Posted by stasinek

See step by step: https://youtu.be/lu1luOtfvXY

thanks you're kindman..

Pivot : Group Data Problem

LinkBack

Thread Tools

Rate This Thread

Display

Pivot : Group Data Problem

Re: Pivot : Group Data Problem

Re: Pivot : Group Data Problem

Re: Pivot : Group Data Problem

Re: Pivot : Group Data Problem

Re: Pivot : Group Data Problem

Re: Pivot : Group Data Problem

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Can't group Data in Pivot Table

how to create group in pivot table data

Excel 2007 : How to group data in pivot table without impactng other tables using same source data

Pivot Table Problem - 'Cannot group that selection'.

Pivot Table group problem

Pivot Table group problem

[SOLVED] Why does the pivot table not allow me to group data?

Group Pivot data by week

Bookmarks

Bookmarks

Posting Permissions