MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
12Next
Return Post new threads
View: 659|Reply: 13

Sorting FY in Power Pivot

[Copy link]

3

Topics

20

Posts

53

Integral

Member

Rank: 2

Integral
53
Post on 9-14-2016 18:30:30 | All posts |Read mode
Morning - Power Pivot is in the middle of giving me fits.

I know the sorting function for monthly analysis is a pain, but any advice on this would be greatly appreciative.
I have 4 separate Pivot Tables within on sheet, which all relate back to a larger file.  
Within each of these Pivot Tables, I have Customer #, NAme, Reps, etc, along with the Month and FY (I also have Month Name and Fiscal Yr, because I can't sort correctly).   I have 2 problems currently.
1. I can't find the best way to get each pivot table to go from Jan FY 12, Jan FY 13, etc...to Jan FY 12, Feb FY 12, etc...Thought I had it one time, but I was kicked off server and now can't remember how it was done.
2. My pivot table needs to expand each month to add the next month - how can I do this?  I always get the Pivot Table cant overlap error...
Any help or questions to make this better would be greatly appreciated.
Thanks,




Reply

Props Report

0

Topics

18

Posts

46

Integral

Member

Rank: 2

Integral
46
Post on 9-14-2016 19:48:16 | All posts



First, this is the PowerPoint forum, not PowerPivot.

The sorting is a lot simpler if you can put the FY part before the month.
You need to have blank rows and columns in between the pivot tables if you must have them on the same sheet. You can hide the excess blank rows and columns until they are needed.











Reply Support Opposition

Props Report

3

Topics

20

Posts

53

Integral

Member

Rank: 2

Integral
53
 Author| Post on 9-14-2016 20:16:13 | All posts



haha - well, in reality I was only one letter off from being Pivot...
THanks for the response - I'll hopefully get this figured out soon, big project due mid-week...




Reply Support Opposition

Props Report

0

Topics

18

Posts

46

Integral

Member

Rank: 2

Integral
46
Post on 9-14-2016 21:09:15 | All posts



You have committed two sins in this forum. You are blatantly linking to a commercial web site - I've removed the links in your original, and you are asking a question in the thread of someone else.
Have you read the forum rules and is there any reason why you should not be sanctioned?
Reply Support Opposition

Props Report

0

Topics

18

Posts

46

Integral

Member

Rank: 2

Integral
46
Post on 9-30-2016 09:29:24 | All posts



First, this is the PowerPoint forum, not PowerPivot.

The sorting is a lot simpler if you can put the FY part before the month.
You need to have blank rows and columns in between the pivot tables if you must have them on the same sheet. You can hide the excess blank rows and columns until they are needed.











Reply Support Opposition

Props Report

2

Topics

8

Posts

30

Integral

Member

Rank: 2

Integral
30
Post on 9-30-2016 11:33:20 | All posts



You have committed two sins in this forum. You are blatantly linking to a commercial web site - I've removed the links in your original, and you are asking a question in the thread of someone else.
Have you read the forum rules and is there any reason why you should not be sanctioned?











Reply Support Opposition

Props Report

3

Topics

20

Posts

53

Integral

Member

Rank: 2

Integral
53
 Author| Post on 9-30-2016 13:09:38 | All posts



Thanks................
Reply Support Opposition

Props Report

0

Topics

18

Posts

46

Integral

Member

Rank: 2

Integral
46
Post on 9-30-2016 10:31:16 | All posts



First, this is the PowerPoint forum, not PowerPivot.

The sorting is a lot simpler if you can put the FY part before the month.
You need to have blank rows and columns in between the pivot tables if you must have them on the same sheet. You can hide the excess blank rows and columns until they are needed.











Reply Support Opposition

Props Report

0

Topics

18

Posts

46

Integral

Member

Rank: 2

Integral
46
Post on 9-30-2016 13:36:15 | All posts



Thanks................
Reply Support Opposition

Props Report

0

Topics

18

Posts

46

Integral

Member

Rank: 2

Integral
46
Post on 9-30-2016 12:18:54 | All posts



First, this is the PowerPoint forum, not PowerPivot.

The sorting is a lot simpler if you can put the FY part before the month.
You need to have blank rows and columns in between the pivot tables if you must have them on the same sheet. You can hide the excess blank rows and columns until they are needed.











Reply Support Opposition

Props Report

12Next
Return Post new threads

Points policy of this forum

Archiver|Mobile|Small dark house|Contact us|Excel Bar

GMT-5, 11-20-2017 00:40 , Processed in 0.260977 second(s), 20 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

!fastreply! Top !return_list!