Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
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
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
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.
Thanks for offering the help,
I'm so sorry is there an instruction or somthing on how to create a downlad excel file?
Thanks
Has anyone experienced such issue when doing a quick pivot table?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |