1 Reply Latest reply on Aug 6, 2018 3:56 PM by Patrick A Van Der Hyde

# 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: Tableau Calculations

Helllo Teja,

Do you have a packaged workbook to show what you have tried?   And I'm not sure how Mapping values apply here.  Please expand on the description of what you are trying to do related to mapping.

Packaged workbooks: when, why, how

Thank you

Patrick