7 Replies Latest reply on Feb 5, 2019 2:35 AM by Shruthi B S

Logic required

Shruthi B S Feb 1, 2019 9:09 AM

Hi All,

I wanted to know a logic to tackle my requirement. I have attached sample workbook for reference.

Sample data is as below. I have partners & Customers tagged for every order.

End result required is as below,

XYZ=100(Partner Booking) + 200 (Customer Booking)=300

Could you please suggest some logic to achieve the result.

Regards,

Shruthi

1. Re: Logic required

Deepak Rai Feb 1, 2019 9:19 AM (in response to Shruthi B S)
Just Pivot Your Data
Thanks
Deepak
If it Helps, Pl Mark it Helpful and CORRECT to Close Thread

Book4_v10.5.twbx 14.9 KB
Like Show 1 Likes(1)

Actions
2. Re: Logic required

Shruthi B S Feb 1, 2019 9:23 AM (in response to Deepak Rai)

Deepak,

Pivoting the data is not possible. This is just the sample simulation of real data. Initially partners & customers are determined based on multiple criteria in the actual project.
Is there any other way to get the result.

regards,
Shruthi
Like Show 0 Likes(0)

Actions
3. Re: Logic required

Deepak Rai Feb 1, 2019 9:35 AM (in response to Shruthi B S)

Let me Try
Like Show 0 Likes(0)

Actions
4. Re: Logic required

Deepak Rai Feb 1, 2019 9:44 AM (in response to Shruthi B S)

I think in this case you may use Custom SQL TO PIVOT from Source.
Like Show 0 Likes(0)

Actions
5. Re: Logic required

Shruthi B S Feb 4, 2019 9:21 AM (in response to Deepak Rai)

Deepak,

I have connected to Tableau server data source. Hence I can't write custom SQL.
Like Show 0 Likes(0)

Actions
6. Re: Logic required

Deepak Rai Feb 4, 2019 9:40 AM (in response to Shruthi B S)

How big is your data?
Like Show 0 Likes(0)

Actions
7. Re: Logic required

Shruthi B S Feb 5, 2019 2:35 AM (in response to Deepak Rai)

There is enormous volume say more than 5M records.
Like Show 0 Likes(0)

Actions