Formatting Pie Charts to maximum of n slices

[system]

Got Help from the below post:

120×120 10.4 KB

Lets say I have 100 counties in a dimension object and census in a measure. I want to build a pie chart that shows the Top 10 counties by census, which is easy to do with adding a rank on the pie. Doing that doesn’t look right however, because the slices are sized based on the census of those 10 counties only. Therefore, I want to add an 11th slice with “Other Counties” so the Top 10 are proportional to the entire pie/census. I tried adding a dimension object: IF(rank([county];[census]) <=…

---

nemesis7 (BOB member since 2010-07-26)