-
1. Re: Split dimension values as per another dimension values
Zhouyi ZhangFeb 1, 2019 4:47 AM (in response to m ovess)
Hi, Ovess
Please find my solution attached
basically, you need join your data to itself using the key firm <> firm(sheet11) as shown below
Here is the result
Hope this helps
ZZ
-
Book2_v10.2.twbx 10.3 KB
-
-
2. Re: Split dimension values as per another dimension values
m ovess Feb 1, 2019 4:54 AM (in response to Zhouyi Zhang)Thanks for looking inot this.
i tried to do join but datasize is over 60M so it's taking lot of time for extraction. is there any way in tableau.
-
3. Re: Split dimension values as per another dimension values
Zhouyi ZhangFeb 1, 2019 5:01 AM (in response to m ovess)
-
4. Re: Split dimension values as per another dimension values
m ovess Feb 1, 2019 5:19 AM (in response to Zhouyi Zhang)i am trying to create field like MY_Firm and Comp_firm
My_Firm
if firm='ABC' then firm end
Comp_Firm
if firm!='ABC' then firm end
but when i am putting it on shelf it's giving null
My_Site Cmp_Site
ABC NULL
NULL XYZ
TUV
-
5. Re: Split dimension values as per another dimension values
Zhouyi ZhangFeb 1, 2019 5:23 AM (in response to m ovess)
you actually can't do it from calculation field as there isn't a relateion ship for each individual firm within the same row, they are very independently.
-
6. Re: Split dimension values as per another dimension values
m ovess Feb 1, 2019 5:44 AM (in response to Zhouyi Zhang)when i am trying to use fixed LOD, like
{fixed market : if (if firm!='ABC' then firm END )}
it's requiring aggregation on dimension.