
1. Re: Sum of quantity based on profit baskets (LOD & Aggregation)
Kaz Shakir Mar 31, 2017 7:55 AM (in response to Benjamin Moerman)Benjamin,
I'm not sure if this is what you are after, but take a look and let us know.
First, I changed your unit price calculation to no longer use aggregations  you shouldn't need that there:
This allowed the your Basket calculated field to now be changed from a measure to a dimension  and so I did that.
Changing those two fileds broke the viz a little bit, and I had to replace the [unit profit] field on the Measure Values shelf, this time with a SUM aggregation, and had to replace the [Basket] field on the Rows shelf with no aggregation (since it's now a measure).
Finally, I created a calculated field to total up the quantity for the viz, leaving out the customer name and product name:
Hope that's helpful. Please let us know if this addresses your question, or raises more.
Kaz.

2. Re: Sum of quantity based on profit baskets (LOD & Aggregation)
Jim Dehner Mar 31, 2017 8:12 AM (in response to Kaz Shakir)Hi Kaz
I am not on the same version of Tableau (10.1) but lets see if this makes sense for you
The result looks like this
The calculations that I used are at the Customer cust unit profit > { FIXED [Customer Name]: Sum([Profit])/sum([Quantity]) }  this could be customer or customer category or any other combination 
Then new buckets .if [cust unit profit]<0 then "below 0" ELSEIF [cust unit profit]<10 then "010" else "above 10" END puts the customers into buckets  this becomes a dimension
The viz is just a plot of Order date (months) on the columns and the New Buckets on the Rows (I added Years on the rows shelf also to let you look across years
Sum[Quantity] goes on the detail shelf  for an additional level of information I put profit ratio on color
In the filters there are category and months that can be used in some detail to look at different levels along product
Let me know if this helped
Jim

4. Re: Sum of quantity based on profit baskets (LOD & Aggregation)
Jim Dehner Mar 31, 2017 9:39 AM (in response to Benjamin Moerman)Glad it worked for you
This was a really interesting problem
Glad to help out
Jim