Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Currently, I have =RegionCode as a 2nd dimension in a bar chart, where RegionCode is a table field. The request is to put a sales variance count after the RegionCode. So I'm trying to concatenate RegionCode with a set expression as follows, and keep getting "Invalid Dimension".
RegionCode & ' - ' &
(
count({< StatusCurr={'Actual'}, SourceCurr={'JDE'}, ActivityTypeCurr={'Agreement TBI'} , LotStatusCodeCurr={$(vLotStatusCode)}, ActivityDateCurr={">=$(=Timestamp(YearStart(left((vCurrentDate),10), 0,11)))<=$(=Timestamp(left((vCurrentDate),10)))"}>} ActivityTypeCurr)
-
count({< StatusCurr={'Actual'}, SourceCurr={'JDE'}, ActivityTypeCurr={'Agreement Lost'} , LotStatusCodeCurr={$(vLotStatusCode)}, ActivityDateCurr={">=$(=Timestamp(YearStart(left((vCurrentDate),10), 0,11)))<=$(=Timestamp(left((vCurrentDate),10)))"}>} ActivityTypeCurr)
)