Pivottable Qtr's

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all
I'm grouping data by Qtr's and by months on column headings. Qtr1 always
starts at the January, but I want to get Qtr1 to start in April ??

Help!

reagrds
johnb
 
Add a column into your source data to calculate the quarter. I don't think
you can change the grouping option for when quarters start.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Group qtr's in pivottables 2
Need to know how data is grouped in PivotTables 1
Formula needed for Sum(A1:C1) then Sum(D1:F1) in next cell 7
Simple copying and pasting macro 1
Form Open 1
Reference page header to query parameters 2
Monthly Update 1
Column Number as parameter in Query to select data 1

Back
Top