Forum Discussion
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 Table via Power Pivot
So far so good however the result in Pivot Table can't do Subtotal?
In the Filed Setting the Custom option is greyed out
Can someone please point out the reason and possible solutions?
Regards,
Wendy
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
9 Replies
Has anyone experienced such issue when doing a quick pivot table?
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
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
Hi,
Share the link from where i can download your Excel file.
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
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
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
