Hi! I am new to Tableau and I have been trying to sort out this issue for a while. I looked for similar issues in the forum and I was able to do some progress but then I got stuck again.
Situation: I have a dimension that includes more than 10 different ethnicities of England, which I grouped into five: White British & Irish, Other White, Mixed/Other, Asian, Black. I have been trying to calculate the proportion between the last four categories and the total of the population.
1) I created different calculations for each group: IF [Ethnicity(groups)] = "Asian" then [Totals Pivot Table] END I did this for each group.
2) The problem is when I create the calculated field: Asian Total+Black Total+Other White Total+Mixed/Other Total (this would be later called "Total BME") this calculation turns up null and therefore I can't use it when I try to do Total BME/Totals Pivot Table
Well, I guess will be better if you have a look at it. I called the calculation that is not working as "NOT WRKNG". Would be great if I can get some guidance.
Thank you so much in advance, really appreciate the help!
Diego
Hi Diego,
Append the calculation with
ZN like below
Total BME
Final View:
ZN because you are using IF Condition false condition giving NULL,
So NULL + anything will give NULL
Hope this helps kindly mark this answer as complete or helpful so that it will help others
BR,
NB
