My requirement is to get a KPI that displays the amount of costs, that external services caused in ratio to my revenue for the current year. So the value of the KPI shall stay the same when I change my filters.
Thanks for your help anyway and sorry for my bad explanations, as english is not my native language the technical terms aren't always in my mind.
Thanks for the reply. I think we're getting closer. Now the value stays the same, but it shows the result of all given data, but not of the current year. Seems to be logic for me as "1" includes (as far as my knowledge goes) all given data. But I wonder, why "$" doesn't work, maybe do I have to change something else in my data editor?