Hello...I need to create a stack graph where the values of my dimension are stacked instead of the expressions. I need a bar for each expression. I have expressions for Hires, Transfers In, Terms, Transfers Out, and Net. My single dimension is a field called Level, which can have values of C14, C15, and C16. Is this even possible?
For example, in the Hire bar, I would have C14, C15 and C16 stacked.
You need 2 dimensions to get the chart you want to display
1) First one create a calculater dimension = "1"
2) Second : Level
Expression : Sum(Hires)
This works with only one expression
You have another solution to display all your expression but you have to transform your data in the script. I don't know if you have this possibiliy. If so Use CrossTable to create a new field call "Variable" which can take the values Hires, Transfers in....
Your final table must have 3 fields : "Variable" , Level, Value
