An easy solution to your complex problems: enter the Bime calculation engine. Want to group things dynamically, filter them based on complex rules or measure the impact of a change on your other numbers? Bime's calculation engine has everything you need, and even more. Don't be afraid to write functions; we have a beautiful user interface for generating most common calculations.
This video will help you better understand calculated measures and attributes, variables, groups, sets, and fixed measures in Bime. It takes you through how to create each one, and shows examples of how they can be used. This video will empower you to ask absolutely anything you want of your data using Bime!