3 Replies Latest reply: Nov 13, 2009 7:18 PM by Peter Rieper RSS

    CALCULATION CONDITION

    dcroft

      Hi,

      In a Pivot table could someone tell me how the calculated condition works?

      I have a master table and a detail table such as

      master contains 2 rows with values 'A' and 'B'

      detail table contains 3 rows, 2 for 'A' and 1 for 'B'

      I want to have 2 pivot tables - one which shows values for the row with 'A' and one for the rows with 'B' and I would like to be able to set this for each Pivot table as a condition rather than the user having to select it

      Any ideas?