1 of 1 people found this helpful
Try wrapping Product Category in ATTR().
ATTR([Product Category]) + ' - ' + [Savings Category]
MAX(STR(INT(SUM(Current Annual Category Cost)-SUM(Adjusted Annual Category Cost)))+" "+ATTR(Product Category))
This will do
MAX - being used if there is any granularity causing NULL value and concatenated value it will remove the NULL value and give the final Concatenated Value
You may need to adjust the table calc of Savings or look at relative filter values. Those might be filter options associated with other service / procedure combinations.
Feel free to provide a data dump in excel and I can provide additional guidance.