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???