Forum Discussion
Data pivot table lab data
Hi, I need to process some lab data with excel, and i think a pivot table is the solution for this. I was almost there, but now there is still a problem i cannot fix myself. I will try to explai...
Click on Count of REPORTED VALUE under Σ Values in the lower right corner of your screenshot.
Select Value Field Settings from the drop-down menu.
Select Sum instead of Count as summary option.
Hi Hans, thank you for your help! But still not that what i should want. I need no sum or count, just the exact value that is linked to the sample ranked by row and analysis ranked by column.
A pivot table always summarizes data, either by counting them, or calculating the sum, average, ....
So a pivot table is not what you need...
- Ok thank you Hans. But i guess this must be possible with Excel of course.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?