Introduction
Average and standard deviation of values in each pivot table row can be calculated and displayed by selecting the "StdDevErrorColumns.postpvtjs" in the post pivot column section in the presets:
After selecting this post pivot column for each row belonging to the same column group the average value and standard deviation will be added as a separate column like in the example below:
This article will show two strategies for how samples can be grouped. Grouping samples is required prior to the addition of the average and standard deviation column.
1. Add Custom Columns to the Samples Table
Add columns to the samples table during project creation and define which sample belongs to each category. By selecting the category as the top header in the report, the samples get grouped accordingly, enabling the average and standard deviation calculation as shown in this picture:
One disadvantage of this approach is that it can only be done during Project Creation. Custom columns cannot be added to the sample table after Project Creation.
2. Change the File Alias Names
Assign an alias name to your samples, either during or after Project Creation, that follows the following pattern:
s(ConditionX)r(ReplicateX)
ConditionX and ReplicateX can be any value of any type (no matter if text or number). See below an example:
After renaming the alias names, two pre-pivot columns need to be added. Go to the presets and select in the first step "SeperateSamples.prepvtjs" and name the column (here in the example below "Samples"). In order to add the pre-pivot column "Replicates", select "SeperateReplicates.prepvtjs" in the presets:
3. Create the Pivot Table
After applying either step 1 or 2, two columns are added to the flat input table (in this example "Samples" and "Replicates". Now, you can create a pivot table similar to this one:
Apply the step that was described in the introduction and as a result both sample groups get two additional columns as shown in picture 2.