Decimal value in pivot table

%3CLINGO-SUB%20id%3D%22lingo-sub-2862079%22%20slang%3D%22en-US%22%3EDecimal%20value%20in%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2862079%22%20slang%3D%22en-US%22%3EIn%20my%20source%20sheet%20I%20have%20decimal%20value%20(0.04)%20when%20I%20use%20that%20column%20in%20viot%20table%20in%20values%20it%20treating%20as%20(1).%20I%20want%20exact%20value%20to%20show%20in%20graph.%20Can%20you%20suggest%20how%20to%20do.%20I%20am%20new%20to%20pivot%20table%20creation.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2862079%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2862577%22%20slang%3D%22en-US%22%3ERe%3A%20Decimal%20value%20in%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2862577%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1189990%22%20target%3D%22_blank%22%3E%40DalluDivya%3C%2FA%3E%26nbsp%3BI%20suspect%20that%20you%20have%20set%20the%20value%20field%20to%20count%20values%20in%20stead%20of%20sum%20values.%20Alternatively%2C%20the%200.4%20is%20not%20a%20real%20number.%20Then%2C%20the%20pivot%20table%20can%20only%20count%20the%20number%20of%20occurrences.%20If%20this%20doesn't%20make%20sense%2C%20please%20upload%20you%20schedule%2C%20or%20at%20least%20a%20representative%20sample%20of%20it%20without%20disclosing%20any%20confidential%20information.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
In my source sheet I have decimal value (0.04) when I use that column in viot table in values it treating as (1). I want exact value to show in graph. Can you suggest how to do. I am new to pivot table creation.
1 Reply

@DalluDivya I suspect that you have set the value field to count values in stead of sum values. Alternatively, the 0.4 is not a real number. Then, the pivot table can only count the number of occurrences. If this doesn't make sense, please upload you schedule, or at least a representative sample of it without disclosing any confidential information.