They won’t work in Excel for Android, Excel for iOS, or Excel for Mac.ĭAX stands for Data Analysis eXpressions. I want to report the text from the Status field in the Values area of a pivot table.” While the Data Model, introduced in Excel 2013, and CONCATENATEX provide a solution, these calculations are only available in Windows versions of Excel. The attendee said, “I have a data set showing the prior and current status for support tickets.
