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
12
Return Post new threads
Author: RO24

Sorting FY in Power Pivot

[Copy link]

0

Topics

18

Posts

46

Integral

Member

Rank: 2

Integral
46
Post on 10-2-2016 12:19:43 | 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 10-2-2016 14:40:56 | All posts



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

Props Report

0

Topics

632

Posts

1471

Integral

Super moderator

Rank: 8Rank: 8

Integral
1471
Post on 11-5-2016 11:38:14 | All posts



Hi
When I first read your post I had assumed you were talking about a Sort as understood by Excel. i.e. a simple sort by either rows or columns. Your data does not lend itself to an easy solution which would probably need a macro.
However if you are prepared to accept a slightly different layout then a Pivot Table is the obvious choice. It takes only seconds to make whereas a macro or some sort of series of complex formulae might take an hour or more.
See attached








  • entry.xlsx
    (19.3 KB, 17 views)
    Download

  • Reply Support Opposition

    Props Report

    14

    Topics

    1362

    Posts

    2928

    Integral

    King

    Rank: 6Rank: 6

    Integral
    2928
    Post on 12-13-2016 07:55:03 | All posts



    Hi,
    You should probably be adding that as a measure in the pivot table rather than as a calculated column in the table.
    Reply Support Opposition

    Props Report

    12
    Return Post new threads

    Points policy of this forum

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

    GMT-5, 11-18-2017 08:49 , Processed in 0.211501 second(s), 17 queries .

    Powered by Discuz! X3

    © 2001-2013 Comsenz Inc.

    !fastreply! Top !return_list!