Thanks very much for the quick answer. Unfortunately creating a set doesn't work for this.
It groups the top 10 vendors at vendor level.
I need a group of top 10 vendors at vendor and date group level.
The amount for the top 10 vendors for each date group should sum to : 80,478,779
In the pie you created it sums to : 76,237,461
But this is exactly the graph type I'm looking to create.
any idea ?
I think the correct value is
Are you sure about 80,478,779?
Sorry for being quick and dirty with my answer.
Setting Top 10 & Others for each particular Date Group
requires RANK() and Table Calculations after that.
Please find the attached w/mods.
Tableau forum_YF.twbx 249.5 KB
Thanks very much for the answer. Nice trick to split the sum in 2 fields.
Again, thanks !