Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I get Sum of Rows value on a Expression/Field from Straight Table in a Text Box?
The Expression is a simple Count(Field) but there are many dimensions in the Straight Table. Should I list all the dimensions under Aggr() ? I don't show all the Dimensions at once. What happens then.
It depends on what dimensions and expressions you are using in your straight table.
Can you provide dimensions and expressions here?
QW,
You could use the aggr() function inside a sum() to get the same result as a sum of rows in a table. The aggr() would calculate the expression for each combination of dimension values - just like straight table does.
I hope that helps.
The Expression is a simple Count(Field) but there are many dimensions in the Straight Table. Should I list all the dimensions under Aggr() ? I don't show all the Dimensions at once. What happens then.
You can use something like this
SUM(Aggr(Count(Field),Dim1,Dim2,Dim3))
Add all your dimensions inside aggr.
You selected your answer as correct???
Strange