-
1. Re: Buckets wise sum for Products ( Rank | Index | Bins )
Zhouyi ZhangNov 7, 2017 5:10 AM (in response to Sumeet Bedekar)
2 of 2 people found this helpfulHi, Sumeet
Please find my solution below.
Basically, you need 3 calculation fields, the sample below I just use the same logic you used up to the 41-50 group and put everything else as other, you can expand to any level as you need.
Hope this could help
ZZ
-
2. Re: Buckets wise sum for Products ( Rank | Index | Bins )
Sumeet Bedekar Nov 7, 2017 9:35 AM (in response to Zhouyi Zhang)Hi
This exactly what I was looking for....
I never thought of using % mod live ... This is truly new learning for me.
However it looks like I am missing something.
Could you please help me with workbook or correct if I am doing anything wrong...Value are incorrect in my result
Regards,
Sumeet
-
3. Re: Buckets wise sum for Products ( Rank | Index | Bins )
Zhouyi ZhangNov 7, 2017 3:38 PM (in response to Sumeet Bedekar)
Hi, Sumeet
Please find a sample workbook in 10.0.
ZZ
-
sample of group sum.twbx 1.2 MB
-
-
4. Re: Buckets wise sum for Products ( Rank | Index | Bins )
Sumeet Bedekar Nov 9, 2017 3:08 AM (in response to Zhouyi Zhang)Thank you so much for this lesson.
Works perfectly and this is exactly what I was hoping to learn. Thank you
-
5. Re: Buckets wise sum for Products ( Rank | Index | Bins )
Zhouyi ZhangNov 9, 2017 4:02 AM (in response to Sumeet Bedekar)
No worries, glad to help
enjoy Tableau
ZZ
-
6. Re: Buckets wise sum for Products ( Rank | Index | Bins )
Chloe S May 14, 2018 11:49 AM (in response to Sumeet Bedekar)Hi ZZ,
The solution you posted is exactly what I want. However can you please add another calculation that does the % of total for each TopN grouping? Total summation of each Top N group divided by the window sum of sales. Thanks.
-
7. Re: Buckets wise sum for Products ( Rank | Index | Bins )
Zhouyi ZhangMay 14, 2018 5:56 PM (in response to Chloe S)
Hi, Chloe
I replied to your posted thread with updated workbook.
Let me know if you have question
ZZ
-
8. Re: Buckets wise sum for Products ( Rank | Index | Bins )
Chloe S May 15, 2018 2:00 PM (in response to Zhouyi Zhang)Hi,
It worked until I added another dimension which is the 'Qtr'. The Total sales and % of sales by Rank Group does not work. I will be uploaded a sample data that is more in line with what I'm working on.
Thanks so much ZZ. I saw you helped us users with some of the difficult questions. You're one of the best there!
Best,
On Monday, May 14, 2018, 5:57:08 PM PDT, Zhouyi Zhang <tableaucommunity@tableau.com> wrote:
|
Tableau Community
|
Buckets wise sum for Products ( Rank | Index | Bins )
reply from Zhouyi Zhang in Forums - View the full discussion
Hi, Chloe
I replied to your posted thread with updated workbook.
Let me know if you have question
ZZ
Reply to this message by replying to this email, or go to the message on Tableau Community
Start a new discussion in Forums by email or at Tableau Community
Following Buckets wise sum for Products ( Rank
Index
Bins ) in these streams: Inbox
This email was sent by Tableau Community because you are a registered user.
You may unsubscribe instantly from Tableau Community, or adjust email frequency in your email preferences
-
9. Re: Buckets wise sum for Products ( Rank | Index | Bins )
Chloe S May 16, 2018 9:44 PM (in response to Zhouyi Zhang)Hi ZZ,
I have the updated Tableau file under this discussion 'Top N with more dimension'.
Thanks much,Chloe
On Monday, May 14, 2018, 5:57:08 PM PDT, Zhouyi Zhang <tableaucommunity@tableau.com> wrote:
|
Tableau Community
|
Buckets wise sum for Products ( Rank | Index | Bins )
reply from Zhouyi Zhang in Forums - View the full discussion
Hi, Chloe
I replied to your posted thread with updated workbook.
Let me know if you have question
ZZ
Reply to this message by replying to this email, or go to the message on Tableau Community
Start a new discussion in Forums by email or at Tableau Community
Following Buckets wise sum for Products ( Rank
Index
Bins ) in these streams: Inbox
This email was sent by Tableau Community because you are a registered user.
You may unsubscribe instantly from Tableau Community, or adjust email frequency in your email preferences