I have the following code in dimensions tab on my pivot table:
Where date_ship is a datetime variable. But it give me an error like "Error in Calculated Dimension"
Anyone knows waht's happening?
To use Max in your dimension you will need to use with Aggr() function. Try this:
You would need to use something dimensional as dimension, not a scalar.
Like a field, or
=Aggr( Date(Max(date_ship)), DimensionForMaxDateField)
Replace the aggr() dimension with appropriate field name(s).
You can't use aggregation function directly in Dimensions expression. You need use AGGR function
Retrieving data ...