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