-
1. Re: Normalize Total based on Category selection
Nick Jastrzebski Aug 14, 2019 4:14 AM (in response to Vipul Khandelwal)Hi Vipul,
You can do this using a percent of total, multiplied by the total value in the data set using both table calculations and a level of detail calculation. In the attached workbook I have done it for Sales:
I would advise caution here though, as you may end up misrepresenting values. Simply using a percent of total would be safer to avoid misinterpretation.
-
Normalise values.twbx 2.4 MB
-
-
2. Re: Normalize Total based on Category selection
Vipul Khandelwal Aug 14, 2019 4:31 AM (in response to Nick Jastrzebski)Hi Nick,
I am not able to open your attached file.
-
3. Re: Normalize Total based on Category selection
Nick Jastrzebski Aug 14, 2019 4:36 AM (in response to Vipul Khandelwal)Hi Vipul,
What version of Tableau are you using? I can downgrade the workbook as far as 10.2 so you can open it on your version.
-
4. Re: Normalize Total based on Category selection
Vipul Khandelwal Aug 14, 2019 4:55 AM (in response to Nick Jastrzebski)Hi Nick,
i am using Tableau 10.5
can you please downgrade your workbook version? I hope it will open then.
-
5. Re: Normalize Total based on Category selection
Nick Jastrzebski Aug 14, 2019 4:58 AM (in response to Vipul Khandelwal)Here you go. You should be able to access that.
-
Normalise values_v10.5.twbx 2.4 MB
-
-
6. Re: Normalize Total based on Category selection
Vipul Khandelwal Aug 14, 2019 5:34 AM (in response to Nick Jastrzebski)Thank you very much Nick. it is working very well as per my requirement.