I am having a pivot table in which i have calculate reference units.
Now according to the reference units in pivot table i have to show those units, which are coming for each "test&measurement type" in a separate table or list box.
below is the screen shot of pivot table. As shown below as unit no - 6 is coming for all Test&Measurement Type so i want to show unit no 6 in separate table/list box or if it is possible in the same table.
Please help pe to slove this problem.
I also attached the sample application and data.