Pivottable Qtr's

J

johnb

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
 
J

Jim Thomlinson

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

Grouping in Powerpoint 0
Percent Help 2
Conditional columnar graph 1
Group qtr's in pivottables 2
conditional formatting of columns in a column chart 0
Formula needed for Sum(A1:C1) then Sum(D1:F1) in next cell 7
Reference page header to query parameters 2
Need to know how data is grouped in PivotTables 1

Top