Summing Unique Values
-
Hello I would like to be able to add my unique values together. Is there a way to do this? I have box Office numbers for different movies and I would like to be able to add them together for each studio and be able to get an average of how much was earned by each Studio.
-
2 Comments
-
Sarah - This is a typical use of SUBSET functions in formulae columns: If you have a tabular data set with columns [Studio], [Movie] and [Box Office] you would add a formula for AVERAGE BOX OFFICE like this:
SUBSET_MEAN([Box Office],SUBSET[Studio]))
I have posted a little example, which also shows how to display the results in both Grouped and Aggregated Table View displays.
-
Here is an example file....files like these are the best way to learn...not with thosands of rows of real client data ;>)Attachments
SUBSET_MEAN_EXAMPLE.iok 7K
Welcome!
It looks like you're new here. If you want to get involved, click one of these buttons!
Categories
- All Discussions2,595
- General680
- Blog126
- Support1,177
- Ideas527
- Demos11
- Power tips72
- 3.0 preview2
To send files privately to Visokio email support@visokio.com the files together with a brief description of the problem.