4-4-5 Calendar

L

Liz J

I typed out my question just a second ago, but I don't think it posted
properly. If I'm repeating myself, I apologize! Anyway, I'm reviewing
annualized financial data that are broken down into weeks. (I have this
information in pivot tables.) I'd like to compare the information year over
year by grouping it in a 4-4-5 calendar format. Is that possible? If so,
are pivot tables the best option?

Thanks for your help!
 
J

Jim Thomlinson

Pivot tables do not support a 4 4 5 natively. To use them for that you need
to attach your week number and year number to each record. That being said no
matter what you want to do you are going to need to attach your week number
and year to each record so a pivot table is as good an option as any.
 

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 Excel data in varying length financial periods 4/5 weeks 2
DATE ORDER FOR QTR 1 -4 5
finding the results of changing 4 variables 3
Pivot Table Dates 1
Missing Pivot Data in Pivot Field (PF)-Weird! 5
IRR - inflow first, followed by only outflows 4
Grouping Data fields in Pivot Tables. 2
Pivot Table Source Data File Path Change 1

Top