Pivot Table new feature "Expand to month/week"

Question

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 apply the "Expand to month/week".who know about that feature and can give me a example or an orientation.
FYI : I'm currently using the 1801 version on Excel 2016 built 9001.2138

sergeibaklan · Answer

Hi Mehdi,
&nbsp;
I'm on 1802.9029.2054 but don't see that in menu.

mehdi hammadi · Answer

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 · Answer

Hi Mehdi,
&nbsp;
Perhaps I missed something with settings, in my case it looks like this

and attached
&nbsp;

mehdi hammadi · Answer

Hi Sergei,
Thank you from the screenshot and for the files. I&nbsp;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

sergeibaklan · Answer

Hi Mehdi,
&nbsp;
I see, that's from sqlbi.com. I used PP Utilities couple of years ago or so quite active, deactivated one day. Reinstalled again right now and have the same menu as you have. Have no idea about expand month/week, it's just filtered the table, didn't catch the logic.
&nbsp;
Tried to check help, but it doesn't work with my browser settings, have only empty screen. Will try to fix some later.
&nbsp;
But you may check if Help works in your environment, they have such item inside

&nbsp;

Forum Discussion

Pivot Table new feature "Expand to month/week"

7 Replies

Resources