I hope you mean like this
Please mark the answer as CORRECT & HELPFUL if it really helps you so that it can help others as well
Please find the attachment as well
calculation.twbx 2.4 MB
does this get saved to the data? what is i want to use the data in another chart, etc, do i constantly have to adjust the table calculation?? anyway i can place it in as a calculated column?
this is one time calculation
Please try yourself and see