3 Replies Latest reply on Jun 15, 2018 2:29 AM by Tal Shaffar

# How to use calculation that are based on Sum of data with another variable

I am a new user to Tablaeu. I can understand how to do basic charts - but I get confused with doing charts based on calculation of sum of data.

(I am sure once I get the hang of it, this question will seem elementary  )

For example...I have this data:

country, StoreType, NumStores, Population

Norway,  Cafe,         15,               5230000

Norway,  Gas,          10,               5230000

Spain,     Cafe,           25,            45000000

Spain,     Gas,            20,            45000000

II want to create a bar graph that shows:

Spain:    (Poulation)/(num stores in Spain)

Norway: (Popuiation)/(num stores in Norway)

For example: Spain would have a value of 45,000,000 / (25+20) = 1,000,000

Thanks!!

• ###### 1. Re: How to use calculation that are based on Sum of data with another variable

Hi Tal,

Please use an LOD for this calculation. It will look like:

min({fixed [Country]: min(Population)})/

min({fixed [Country]:

SUM([Num Stores])})

I've attached the workbook for you to see how it works too.

Thanks,

Mavis

1 of 1 people found this helpful
• ###### 2. Re: How to use calculation that are based on Sum of data with another variable

Hi Tal,

Pl havea  look.

Thanks

Deepak

If it Helps, Pl mark it Helpful and CORRECT to Close Thread

1 of 1 people found this helpful
• ###### 3. Re: How to use calculation that are based on Sum of data with another variable

Got it to work.  Thanks!