Forum Discussion

WL's avatar
WL
Regular Visitor
7 years ago
Solved

Subtotal not available?

Hi all,  Appologies in advance if this questions have been asked many many times, and I'm very new to this realm     I'm running a set of data via power query and has dumped them into a Pivot Tabl...
Need Help
  • shivakumarsokke's avatar
    shivakumarsokke
    7 years ago

    I have added a link and updated my previous screen shot. See if that has solved your problem. On Layout & Print Option under Field Settings you need to enable additional items to enable subtotals

shivakumarsokke's avatar
shivakumarsokke
Regular Visitor
7 years ago

I have added a link and updated my previous screen shot. See if that has solved your problem. On Layout & Print Option under Field Settings you need to enable additional items to enable subtotals

WL's avatar
WL
Regular Visitor
7 years ago

Thanks shivakumarsokke I didn't realised this is a pure pivot table issue when bringing data from external source 

 

The Layout & Print setup has solved my problem, however it's more of a work around? as you can't really do other functions like count etc.

 

Is there are permanent solution under Excel? or have to use Power BI desktop

 

Thanks again