Forum Discussion

Mehdi HAMMADI's avatar
Mehdi HAMMADI
Brass Contributor
Feb 15, 2018

Pivot Table new feature "Expand to month/week"

Hi I'm just noticed some new features related to Excel Pivot tables that are accessible from tghe contextual menu of a PVT (right clik). I understood the use of most off them but I'm not able to a...
BI & Data Analytics
pivot table
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 16, 2018

Hi Mehdi,

 

I'm on 1802.9029.2054 but don't see that in menu.

  • Mehdi HAMMADI's avatar
    Mehdi HAMMADI
    Brass Contributor
    Feb 17, 2018

    Hi Sergei,

    As I wrote this is a contextual menu that appear when I right-click on a pivot table that have as source a Data Table not a Data Model

    Can you please share a screen shot of the contextual menu that appear on you version.

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Feb 17, 2018

      Hi Mehdi,

       

      Perhaps I missed something with settings, in my case it looks like this

      and attached

       

      • Mehdi HAMMADI's avatar
        Mehdi HAMMADI
        Brass Contributor
        Feb 17, 2018

        Hi Sergei,

        Thank you from the screenshot and for the files. I loaded it and got the new features .This helped me an now I know from where these added commands came from.

        Last week I dowloaded and activated an add-in and at the same time a dowloaded and installed the 1801 O365 updated and I toght that this was an update from O365 new version But in fact, the few new features comes from it. The add-in is "PowerPivot Table utilities".

        So I will ask the author to know more about that feature. Thank you again sergei

Resources