6 Replies Latest reply on Aug 14, 2019 5:34 AM by Vipul Khandelwal

Normalize Total based on Category selection

Vipul Khandelwal Aug 14, 2019 3:43 AM

Hi there,

i have a Data Set and then categorized in following view :

Type 1	Value	% of Total
A	10,971	2%
B	4,011	1%
C	32,481	5%
D	111,909	19%
E	129,383	22%
F	72,308	12%
G	222,423	37%
H	16,611	3%
Grand Total	600,097	100%

Requirement is to normalize this data based on selection from column "Type 1" . For an example if i remove values for G or for D and G together distribution should look like this way :

Type 1	Value
A	17,432
B	6,373
C	51,610
D	177,815
E	205,580
F	114,892
H	26,394
Grand Total	600,097

Type 1	Value
A	24,773
B	9,057
C	73,342
E	292,147
F	163,271
H	37,508
Grand Total	600,097

please suggest.

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
Like Show 0 Likes(0)

Actions
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.
Like Show 0 Likes(0)

Actions
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.
Like Show 0 Likes(0)

Actions
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.
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
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.
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Normalize Total based on Category selection

1. Re: Normalize Total based on Category selection

2. Re: Normalize Total based on Category selection

3. Re: Normalize Total based on Category selection

4. Re: Normalize Total based on Category selection

5. Re: Normalize Total based on Category selection

6. Re: Normalize Total based on Category selection

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account