Not very sure if I have understood your requirements correctly.
Anyway I made a workbook similar to your Excel.
And I feel confused about the way Spend is rounded.
Please refer to the attached workbook for details.
Before that, please update your Tableau desktop to 9.3
market (1).twbx 134.6 KB
Hi Lei chen,Thanks for helping this task. sorry for late reply. thank you so much.