Jabberwocky
Expert Member
Do you know if theres a way to group dates in an excel pivottable according to fiscal year instead of calender year? Or am i going to have to change the data on the reference sheet?
-
Join the MyBroadband community
South Africa’s biggest forum. Discuss, discover, and connect with thousands of members.
-
Question of the Day: What's the most interesting small town you've visited in South Africa?
Excel PivotTable grouping
- Thread starter Jabberwocky
- Start date
bigicy
Expert Member
That;s a tricky one....
Will try find out for you....
Will try find out for you....
Other Pineapple Smurf
Honorary Master
Learn scripting, or just write a VBA class
Jabberwocky
Expert Member
I get the data via Microsoft query.
I`ll use t-sql to split the dates into fiscal years. As brilliant as excel is.. i think microsoft slipped up a bit.
I`ll use t-sql to split the dates into fiscal years. As brilliant as excel is.. i think microsoft slipped up a bit.