Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
sushil353
Master II
Master II

Need help to calculate an expression

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

0 Replies