29 Replies Latest reply: Dec 18, 2014 6:58 AM by Shaila Tyagi RSS

    Table Cal help???

    Amit Saini

      Hi Folks ,

       

      See below:

       

      I'm using pivot table , from level1 to Level 5 name are my dimensions and Quantity and Price are expressions .

       

      I'm simply calling Quantity  and Price fields as expression .

       

      Problem here is I'm getting duplicates numbers or values see below :

       

      And If I'm calling only Level 1 and Level 1 Name as dimension and Quantity as expression I'm getting only single value .

       

       

      My requirement here is to show all levels with there respective names as in image but Quantity and Price figures should not repeat.

       

      Any Suggestion???

       

      Thanks,
      AS