Home

custom subtotal in pivot table greyed out

%3CLINGO-SUB%20id%3D%22lingo-sub-843518%22%20slang%3D%22en-US%22%3Ecustom%20subtotal%20in%20pivot%20table%20greyed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-843518%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20work%20out%20a%2013%20week%20average%20for%20my%20work%2C%20however%20when%20i%20go%20to%20field%20settings%2C%20custom%20subtotals%20is%20greyed%20out.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20looked%20online%20to%20try%20and%20find%20a%20solution%2C%20however%20none%20of%20them%20are%20applicable%20to%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20working%20with%20version%201902.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHopefully%20someone%20can%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHannah%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-843518%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-844878%22%20slang%3D%22en-US%22%3ERe%3A%20custom%20subtotal%20in%20pivot%20table%20greyed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-844878%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F405724%22%20target%3D%22_blank%22%3E%40hannahc16%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ethis%20is%20hard%20to%20troubleshoot%20without%20seeing%20your%20data.%20Can%20you%20post%20a%20small%20sample%20file%20with%20dummy%20data%20and%20point%20out%20where%20the%20problem%20is%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20attach%20a%20file%20when%20you%20reply.%20Click%20the%20paper%20clip%20icon%20below%20the%20main%20text%20box.%3C%2FP%3E%3C%2FLINGO-BODY%3E
hannahc16
Occasional Visitor

I am trying to work out a 13 week average for my work, however when i go to field settings, custom subtotals is greyed out.

 

I have looked online to try and find a solution, however none of them are applicable to me.

 

I am working with version 1902.

 

Hopefully someone can help.

 

Hannah

1 Reply

Hello @hannahc16 ,

 

this is hard to troubleshoot without seeing your data. Can you post a small sample file with dummy data and point out where the problem is?

 

You can attach a file when you reply. Click the paper clip icon below the main text box.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies