MDX query with changes to the names of multiple columns and use of the bottomcount function to get the last x number of items in the cube
with member [Measures].[Success] as [Measures].[Sum of SuccessCnt]
member [Measures].[Fail] as [Measures].[Sum of FailCnt]
SELECT
{ [Automated Process Tracker].[Process].[Process].ALLMEMBERS } * { [Measures].[Success], [Measures].[Fail]}
ON COLUMNS,
{ bottomcount([Automated Process Tracker].[Process Date].[Process Date].ALLMEMBERS,10) }
ON ROWS
FROM [APT Tabular]
CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL, FONT_FLAGS, FORE_COLOR, BACK_COLOR