I am working in Google Sheets and in my main spreadsheet's raw data I have salespersons who I keep track of the sales and the units sold. In this one instance, two salespersons shared a deal and so I recorded it in the raw data as .5 each. But in the Google Sheets Pivot Table value of this column summarized by count rounds it to 1 each. Using the decimal place adjuster on the ribbon does not fix this. As you know Google Sheets does not work the same as excel. I can replicate this in Excel and it works perfectly. Is there a fix?
Solved by B. B. in 19 mins