Hi there
I am not sure if the title has the correct terms, I have a developer and am very new to cubes.
I have a cube which has data associated to materials that are broken down into chemical compounds.
For example a rock material has 10% of this chemical and 10% of that chemical, etc. Samples are taken daily and sample is a dimension with date, etc.
So, the measure needs to average by the sample dimension but needs to sum across the chemical compound dimension (To add up to 100% for example).
Is this at all possible?