I have a mistery problem in a pivot table
The formulas are the same as the field names, and when I try to use "min(requesttime)" it throw an error. I think that the result of this dimension must to be at least the same of the previous column (later I will try to get the real min of each key)
Anyone can help me?
Just try Minstring() see if the field is in text format or not?
Perhaps something lile
=min(Aggr(requesttime, dim1, dim2, ...))
Where dim1, dim2, ... are the other dimensions for the pivot table.
The dimensions in the aggr() give the context for the minimum time. The context comes from the dimensions when the min() is a chart expression, but a calculated dimension does not get that same context.
Hey you can not use the normal aggregation functions in dimension without the advanced aggregation function.
If you want to just get a minimum value then use it in expression instead of dimension.
To use in dimension you can try as below.