7 Replies Latest reply on Oct 17, 2018 11:04 AM by Deepak Rai

# Date conversion Help??

I am looking for a way to convert the date

Where January = 12, Feb = 11, March = 10 and so on.
I need to use is in the example below.

the field names are for example

Region, Month and Amount.

I need to create a calculated field where each month will multiply with the number corresponding to the related month.

for example Jan for region ABC has an amount of 541

Calculated field X =  Amount x 12 where tableau determine the value of 12 based on the Month

 Region Jan Feb Mar Apr May Jun ABC 541 123 987 147 741 159 DEF 125 456 654 258 852 753 GHI 356 789 321 369 963 591 Annual Jan Feb Mar Apr May Jun ABC =B2*12 =C2*11 =D2*10 =E2*9 =F2*8 =G2*7 DEF =B3*12 =C3*11 =D3*10 =E3*9 =F3*8 =G3*7 GHI =B4*12 =C4*11 =D4*10 =E4*9 =F4*8 =G4*7
• ###### 1. Re: Date conversion Help??

Hi Emrick

First you need to Pivot your Months, Then write a Calc to assign values and then Multiply.

Thanks

Deepak

If it Helps, Pl Mark it Helpful and CORRECT to close Thread

• ###### 2. Re: Date conversion Help??

Thanks for the help.

I can't pivot the month. the months are under the fieldname "Month" and showing as 1/1/2018, 2/1/2018, 3/1/2018 and so on for each row/record.

• ###### 3. Re: Date conversion Help??

Can I have your data how it looks actually. Make be fake data set..Few lines in excel

• ###### 4. Re: Date conversion Help??

Sure.

Please see attached for excel file

• ###### 5. Re: Date conversion Help??

Here it is:

I used only 5 Months data till May 2016, You can modify my Calcs and do what I did.

Fixing Values to each Month

and then multiply

e.g. 2290x12= 27480

Thanks

Deepak