Forum Discussion
Return sum value based on category
Hi exo
Does CC type stand for Cost center type? I'd greatly appreciate it if you could tell me what you'd like to achive.
Cc type is for classifying the volume in this case.
Direct means that the operation produces volume, so it's directly correlating to the operation.
Other option is Support, which is for the support cost centers. They are not producing volume, but for the benchmark you have to calculate with the total volume.
3rd mentioned option (z category) is connected to the operation but they also don't have volume. Therefore, you need to take only the amount where z category is showing
My aim is here to come up with a solution where I can have all three options in a single measure. This measure would help me in further calculations.
I hope this helps you a bit.
Thanks for your further explanation, but it would help if you can share with me a sample file with an instruction of what you want to see in a calculated column or a measure output.