Calculated Dimension

[evansabres]

I would like to create a calculated dimension for a table.

My field is 'transBUYERTPE' and within that field that are several types of buyer types, such as ADULT, STH

What is the syntax for a calculated dimension to focus in on, for example. a transBUYERTYPE of ADULT?

[robert_mika · Accepted solution]

Try:

=if(transBUYERTYPE ='ADULT',transBUYERTYPE)

the tick the box next to 'Suppress When Value is Null' from

'Setting For Selected Dimension'

[evansabres]

This works perfectly, thank you. Is it possible to have multiple calculated dimensions?

[robert_mika]

Yes you can,

But CD are expensive - is better to use your criteria with Set Analysis

Set Analysis: syntaxes, examples