1 Reply Latest reply on Jul 22, 2018 10:52 PM by Chris McClellan

Need help with Tableau Calculations

Hello Team,

Can some one help me in achieving this scenario,.

My requirement is to replicated the Excel report into tableau.

I have a table with following data..

Mappings                         Jan               Feb                     Mar                Apr

A. Cost of Sales                   1.4M              1.56M                  0.9M              29M

B. Inventory                         0.25M             0.2M                    1.8M              2.75M

C. Vama                              0.32M              0.34M                  3.68M           2.34M

Now my requirement is to find

1. row D. Total  as new row -- which has calculation as follows row B+C-A  and also here for C i.e inventory(for Jan the value should be the same for Feb the values is Jan month's value )

2. row E. as new mapping value needs to be added

3. row F =   E/D

My first question is it possible in tableau?

IF possible can some one help me achieving this. please.

Attaching screenshot of requirement.

• 1. Re: Need help with Tableau Calculations

I got a bit lost on the Row E stuff, but this is what I created: