chart expression: total keyword and calculated dimension
Hi,
In my chart, I have a calculated dimensions that I would like to not ignore in the expression. There is one other calculated dimension that I would like to ignore. So there two calculated dimensions. I want to ignore want and take the other one in the group by of expression
my expression is something like
sum(total rev)
the expression for the rowbreakdim dimension that I dont want to ignore is
which I have labled as rowbreakdim and I want it not to be ignored in the expression
Can someone please tell me how to put this whole calculated dimension in the total key word in the chart expression If I have to ignore the other dimension but not this one?