I have a raw dataset of a very select portion of the population to do analysis on. But I want to bring in the balance of the population as a line item to calculate % of Totals.
For example, my dataset is based on users that have performed a task and the balance of the population (what's not in my dataset) are the users that have not performed a task. I would like to be able to show the results like such:
The blue rows represent the dataset I have. The white row is the balance total I want to bring in for comparison.
Nick - you will want to learn about Level of Detail calculations as they should let you do what you like here. There are a number of helpful resources here in the community. We even have a Think Data Thursday presentation on this topic.