Concatenate a summary number to show an actual and target value
Hi, is there a way to create a beast mode to show a summary number that will actual consist of text. The text I'm hoping to display would be a target value and an actual value. For example I have a Bar chart that has 3 different sets of bars. Let's say Value A, Value B and Value C. Each item would have a Target and an Actual so I would have 3 sets of 2 bars each. I'd like to be able to show the sum of Value A, Value B and Value C as well as the Target of each of those within the same chart however the data is not set up that way so I'm hoping to be able to put something in the summary line that represents the total actual and the total Target. Does that make sense? Is this possible? I'd like the summary line to say Actual - xxx | Target - yyy or something along those lines.