'Is it possible to make a dash table with a dropdown and calculations in some columns?

Hey guys im new to plotly dash and i want to make a dash table from a dataframe with the headers:

branch office, year, month, week, count(count of sales per week), sales volume (per week)

i want to make a table where i have 4 columns which are selected by a dropdown for each column where i can choose a year of the dataframe that shows me the the sales volume for every week of those years and the colums right of the 4 Colums should be calculations where i can determine the difference of two years with difference as number in one column and the percentage differece in another column.

that i have all week 1 values for all years in one row and the calculations too.

Is this possible and what do i need for this?

Thank you in advance.

Greeting LittleStudent



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source