Forum Discussion
SUM vs Target
Hi Anonymous
Something like this? See it all at work in the attached file.
It has a relationship like you described and you can choose what cost centre(s) to show in the slicer. You can modify it if you want a max value different from the target
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Community ChampionHi Anonymous
Something like this? See it all at work in the attached file.
It has a relationship like you described and you can choose what cost centre(s) to show in the slicer. You can modify it if you want a max value different from the target
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hello AlB ,
Thank you for your reply , that was very helpful.
You also gave me the opportunity to dig a little deeper and recreate the same graphs by using measures.
The tricky one was to capture the correct target per area/cost centre.
This is the measure I came up with.
Once I sorted this out, I was then able to create the below graph.
Thank you for your reply.
George