6 Replies Latest reply: Sep 9, 2011 6:13 AM by Sushil Kumar RSS

    How to adjust dimension over expression in pivot table??

    Sushil Kumar

      Hi All,

       

      I have a pivot table in which two dimensions are there 1. Location Desc and 2. Defect type

       

      also in the same table two expression is calculated 1.defect_op_yield_summary and 2. Op_defect_summary

       

      I want to adjust defect_type dimension over op_defect_summary column only...

       

      I am attaching the qlikview file... when i am trying to put defect_type dimention in horizontal then it is applied to both expressions..but i want to put dimention over op_defect_summary type only...

       

      Please help me out .... as client want to see the report only that way....