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

Not sure if I have understood the problem here 100%. But here is what I find that works for me. 

 

I believe you have established the conenctions  under Data tab from where you are reading the source data in the Excel and have selected the Pivot table option under the Insert. 

 

More details on using Pivot with Subtotals Here

 

 

 

 

 

  • WL's avatar
    WL
    Regular Visitor
    7 years ago

    I think you are 100% correct shivakumarsokke

     

    What's reason for that? and how to avoid it in the future? 

     

    I'm sort of practice and learn in the same time 

     

    Wendy

    • 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