Complex filter question

[system]

Not really, they can be a pain in the

You use them to solve specific issues individually.

Like this “other pie” slice.

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]) <=…

---

Joel Seguin (BOB member since 2004-12-08)