
1. Re: Dynamic Categorization of sales and finding number of customers
Shriram Saxena Aug 28, 2016 11:06 PM (in response to Shaji Mathew)Hi Mathew,
Please find the solution attached.
Is this what you are looking for .
Best
Shriram Saxena

Book1.twbx 1.2 MB


2. Re: Dynamic Categorization of sales and finding number of customers
Shaji Mathew Aug 29, 2016 12:49 AM (in response to Shriram Saxena)Hi Saxena,
Thanks very much for your solution.
But I have one problem in using BIN as I need to divide total sales into 10 equal parts..
Assuming the Total is 2297201, it should be as below and need to find number of customers falling whose total sales falls into each category.
TOTAL  90 % OF TOTAL sum([Sales])>229720.1* 9 and sum([Sales]) <=2297201
90 % OF TOTAL  80 % TOTAL  sum([Sales])>229720.1* 8 and sum([Sales])< =229720.1* 9
80 % OF TOTAL  70 % TOTAL  sum([Sales])>229720.1* 7 and sum([Sales])<=229720.1* 8
70 % OF TOTAL  60 % TOTAL  sum([Sales])>229720.1* 6 and sum([Sales])<=229720.1* 7
60 % OF TOTAL  50 % TOTAL   sum([Sales])>229720.1* 5 and sum([Sales])<=229720.1* 6
50 % OF TOTAL  40 % TOTAL   sum([Sales])>229720.1* 4 and sum([Sales])<=229720.1* 5
40 % OF TOTAL  30 % TOTAL  sum([Sales])>229720.1* 3 and sum([Sales])<=229720.1* 4
30 % OF TOTAL  20 % TOTAL  sum([Sales])>229720.1* 2 and sum([Sales])<=229720.1* 3
20 % OF TOTAL  10 % TOTAL  sum([Sales])>229720.1* 1 and sum([Sales])<=229720.1* 2
0  10 % OF TOTAL  sum([Sales])>0 and sum([Sales])>229720.1
Thanks...

3. Re: Dynamic Categorization of sales and finding number of customers
Shriram Saxena Aug 29, 2016 2:54 AM (in response to Shaji Mathew)1 of 1 people found this helpfulHi Mathew,
Try creating Variable SIze bins
Follow Creating Variable Sized Bins  Tableau Software
Best
Shriram Saxena

4. Re: Dynamic Categorization of sales and finding number of customers
Shaji Mathew Aug 29, 2016 8:45 PM (in response to Shriram Saxena)Hi Saxena,
The problem with me is that the sales is dynamic and so the percentage also not just a variable alone.
I cannot categorize based on any fixed values.
Thanks.

5. Re: Dynamic Categorization of sales and finding number of customers
Shriram Saxena Aug 30, 2016 4:26 AM (in response to Shaji Mathew)Hi Mathew,
I think this will solve your problem.
Pls find the Workbook attached...(see Sheet 5)
Best
Shriram Saxena
Book1.twbx 1.1 MB
