Hi,
I have a pivot table that uses a calculated dimension, used as a column, defined as:-
=
Pick(
(
IF(aggr(sum({[Leakage]<
[Wholesaler Type (Wk)]={'Third Party Wholesaler'}, [Transactions.Transaction Effective Month Year]={'<=$(=vLeakageTablePYEnd) >=$(=vLeakageTablePYStart)'}>}[GWP excl IPT]), [Client Name])
> 0,1,0)
+IF(aggr(sum({[Leakage]<
[Wholesaler Type (Wk)]={'Third Party Wholesaler'}, [Transactions.Transaction Effective Month Year]=p([Transactions.Transaction Effective Month Year])>}[GWP excl IPT]), [Client Name])
> 0,2,0)
+IF(aggr(sum({[Leakage]<
[Wholesaler Type (Wk)]={'*'}-{'Third Party Wholesaler'}, [Transactions.Transaction Effective Month Year]=p([Transactions.Transaction Effective Month Year])>}[GWP excl IPT]), [Client Name])
> 0,4,0)
) + 1,
'5. n/a',
'1. lost',
'4. new',
'2. renewed',
'5. n/a',
'3. moved',
'4. new',
'2. renewed')
I then have a couple of expressions and want to hide (or set as null() if unable to hide) when the dimension value is '4. new' the expression is
SUM({[Leakage]<[Transactions.Transaction Effective Month Year]=p({Leakage}[Transactions.Transaction Effective Month Year]), [Wholesaler Type (Wk)]={'Third Party Wholesaler'}>}[GWP excl IPT])
I've tried various combinations of trying to put a conditional in the expression but to no avail!
Thanks, Robert