Decimal value in pivot table

Copper Contributor
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.