1 of 1 people found this helpful
Below is the trick or workaround in order to achieve this.
I have Sales and would like to get % of the sales in a separate column based on what the user enters.
% of Sales would be: ([Enter the %of sales in number]/100)*Sum([Sales])
In the parameter [Enter the %of sales in number] user enters the whole number and we are manipulating it in the calculation by dividing it by 100.
Please find the attached Tableau workbook and hope this what you are looking for.
It would be great, if you could mark this as helpful or answered if you like the solution.
Thanks Venu. I was hoping there was a way to do it inclusive in the parameter format to keep the % symbol in the field rather than moving it to the Header description.