Anyone know a formula to calculate the difference between maximum and median values along a single row?
For example, I have a database of property values and want to show the difference between the top and median. I've set up a dual axis viz that illustrates it but I want to be able to display the actual value in tooltips.
The calculations I'm familiar with all want to compare between rows.
Sorry for the delay in receiving a response! Do you still need assistance with this? If so, can you post a sample workbook (twbx file)?