How to find MAX number on a specific Dimension
Need some help on a logic wherein I need to show Maximum number for a specific Dimension out of 5 Dimensions, for e.g. in the below screenshot I need to bring 49,258 from Line Item "A" (as highlighted) which is contributed by Tennessee (which is one of the States in States Dimension, on columns) on LI "MAX of All States" so that I can divide the respective States' numbers by the maximum of all States (which is Tennessee in this case, which is 6300 / 49258, 7088 / 49258 and so on..). But the challenge here is when applying MAX on as Summary method on LI "MAX of All States" its showing Maximum of "Products", "Accounts" and "Periods" (custom month's list) dimension but within the respective states.
Now the ask is I need to show Maximum value out of all the states when I go within the page selectors.