1 of 1 people found this helpful
It is possible to show max across a dimension which is not shown, using a Table calculation (Lookup). However I don't think that is required to get MAX user count across all purchase dates, because this can be achieved by a simple MAX function.
I just created a calculated field Max Unique Purchase= Max(Unique user Purchases) .
Please let us know if your requirement is more complex ?
I realized I didn't explain the full extent of the challenge. I edited the original question.
There's one more dimension, e.g. Country. Neither Country nor Purchase date will be shown in the report.
I need to get the number of users which is basically a SUM of all (MAX(Unique user purchases) across all dates) for each country. Hope this is clear :-)