CALCULATION CONDITION

[#1]

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?

[#2]

In table 1 change your expression such as IF(Field='A', sum(xxxx),0)

Do the same for the second table chart with IF(FIELD='B',sum(xxxx,0)

[#3]

Hi,

Thanks for getting back to me.

I believe that the above solution would still show a value in each Pivot table for 'A' and 'B' - essentially I want to limit each Pivot table to only show values

'A' or 'B (a bit like a where clause in SQL if you like)

[prieper]

Think you should use a calculated dimension, like

IF(MyDim = 'A', MyDim)

and set suppress Null-Values. Analogue you should handle the other pivot with 'B', You only should think about, what you may do with other values, if they may show up.

HTH
Peter