Show summarized data AND selective individual data points in a PivotTable

Joel Fair

New Member
Joined
Dec 4, 2013
Messages
4
Hi,

I have a set of biological measurements that I am trying to organize. I would like to show both the summarized data and the individual data points within the same table. Is this possible with a PivotTable?

Here is the data in summarized form only:

ccuh.png


The data consists of three replicate experiment values for each sample. Some of my samples only have one or two measurements instead of three, so I've shown the number of replicates per sample that contribute to the summarized data.

I'm able to expand the summarized results into their individual values by including the "Experiment" variable under the "Columns Labels" section of the PivotTable Builder.

rhgc.png


However, this expands all of the summarized results when I'd only like to expand the values that contribute directly to the average. Is there a way that I can do this easily through the PivotTable instead of reformatting it manually? I've done it manually here to give you a better idea of what I mean:

skd3.png




Thank you for taking the time to read this through,

Joel
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

cyrilbrd

Well-known Member
Joined
Feb 2, 2012
Messages
4,094
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
Hi,
So you want only the independent values for ep1, ep3 and ep4 to be shown alongside the # of replicates, average and StdDev?
Excel 2011 right?
 
Upvote 0

cyrilbrd

Well-known Member
Joined
Feb 2, 2012
Messages
4,094
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
How is your Column 'average' arranged?
where do Epx come from? (1,3,4...)
 
Upvote 0

Forum statistics

Threads
1,186,662
Messages
5,959,062
Members
438,396
Latest member
Louise Rodway

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top