Please see attached for what I'm trying to achieve. I'm putting the final results in an Excel spreadsheet and importing it into Tableau to build a dashboard, but need to display the numbers how they are displayed in Excel(the attached picture.) Any help would be greatly appreciated.
If you always want the second part to be one,
then maybe you can try: