3 Replies Latest reply on Dec 6, 2017 3:17 AM by Mark Bradbourne

# Create a dimension

Hello all,,

I would like to create a new dimension linked to an other one.

To explain me;

I have dimension with number : 52 , 51, 10, 63, 54

Each number  hasa correspondance : 52 = other;  51 = customer ; 10 = supplier ; etc.  But i don't have a dimension with this info.

Can i create a new dimension ? Linked to the other one.

In excel i will do a IF formula but here i really don't know what to do. i'm new in tableau.

Cheers,

Laura

• ###### 1. Re: Create a dimension

You can create a calculation with those values, which should yield the same results.

CASE [Dimension Number]

When 52 then 'other'

When 51 then 'customer'

When 10 then 'supplier '

etc.....

END

1 of 1 people found this helpful
• ###### 2. Re: Create a dimension

Thank you very much , it works

Can i ask you an other question ?

I would like to have my measures as 100% for each column.

So in the columns have (ex) 10%     20%

50%     10%

20%     20%

15%     25%

5%       25%

and not   20       60

100     30

40      60

30      75

10      75