Calculated Dimension

[evansabres]

I am looking to create a calculated dimension with multiple values of the same dimension.

The dimension is 'Opponent' and there are eight values. (Opponent A, Opponent B, Opponent C)

What is the syntax of the dimension?

[micheledenardi]

Try to use ValueList function:

Valuelist('Opponent A', 'Opponent B', 'Opponent C')

[sunny_talwar]

8 values? how are they getting into the three Opponents you mentioned (A, B, C)?

[evansabres]

That was an example, there are eight opponents

[sunny_talwar]

Why can't you use opponents as your dimension? Why do you need calculated dimension?

[micheledenardi · Accepted solution]

In your chart use Valuelist('Opponent A', 'Opponent B', 'Opponent C') as a dimension and if() statement to specify the expressions for each dimension value

[evansabres]

There are values in there, which I do not want to have appear in the table.

[sunny_talwar]

Then you can use an if statement

If(Not Match(opponents, 'opponents9'), opponents)