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

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi WL

Based on my knowledge, it is possible to do a pivot table in Power BI.

However, your requirement is not clear, could you show an screenshot or examples?

 

Please see How to Get Your Question Answered Quickly

 

Best Regards

Maggie

WL's avatar
WL
Regular Visitor
7 years ago

Hi Maggie v-juanli-msft

 

Please see below screenshot highlighed with the problem is. 

I'm in excel 365

The background data is loded in via power query, I'm trying to subtotal the Amount by Program Type. The Amount is not calculated and I have formated as Currency 

 

I can try Power BI to see if the poblem will dissapear but at the end of the day I still need Excel to run this particular file 

 

 

 

Thanks

Wendy

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

     

    Share the link from where i can download your Excel file.

    • WL's avatar
      WL
      Regular Visitor
      7 years ago

      Hi Ashish_Mathur

       

      Thanks for offering the help, 

       

      I'm so sorry is there an instruction or somthing on how to create a downlad excel file? 

       

      Thanks