Creating Dynamic Sets

Sets are created from dimensions by formulating specific conditions. When added to the worksheet, the set will highlight which marks on the worksheet are "IN" and "OUT" of the specified set. What makes it dynamic is that when adding or removing fields to the worksheet, the marks within the set will change. Therefore, the marks within the worksheet are automatically organised with according to the set.

Furthermore, we can condition the set to very specific conditions. We can include the specific strings within our choosen dimension that we want to create the set for. For example, we can include all customers who's names start with an A.

You can also condition the set to only show Top/Bottom customers based on a measure. For example, We want to see the top 10 people based on the sales measure

Author:
Muhammad Choudhury
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2025 The Information Lab