I have a workbook with about 50 dimensions (i.e. character attributes with specified domains) and 10 measures.
We can imagine the below dummy dataset:
I would like to perform some "operation" with a dimension (or more than one dimension) and measure combination.
For the sake of simplicity, using the above data I want the sum of incomes for each of the dimension-'domains' to get the following result (ideally I would write a function and pass all the dimensions I have from a list and put the results back in a data set):
Is there a way to do this, without having to create 50 sheets (one for each dimension) and making a union sheet?
Any direction would help! Please let me know if you have any questions regarding the above transformation.
Please sign in to leave a comment.