0 Replies Latest reply: Mar 22, 2012 11:16 PM by Sushil Kumar RSS

    Need help to calculate an expression

    Sushil Kumar

      Hi All,

       

      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.

      pivot tavle.jpg

       

      Please help pe to slove this problem.

       

      I also attached the sample application and data.

       

      Thanks