I you have just a few items (or too much time for more dimensions) you could add a "fake metric column" used for sorting: create a calculated metric with a bunch of "if ... then ... else" formulas and output the desired position. then prder by this row and make is as small as possible (just before it dissapears
the formula would look something like
if (dimension1) "occurencies" greater than 1
then 1 (as static number)
if (dimension2) "occurencies" greater than 1
while (dimension1-X) are just "dimension filters" (drop dimension in metric an select desired value)
if you add this metric to your table it will output a "1" for (dimension1), a "2" for (dimension2) ... and allows you to sort as desired
I know, not the best .... but you asked about a solution
Huh. If you add a new free form table and add dimension items one at a time, they seem appear at the bottom of the list each time. Could obviously use that for manual ordering. However, once you add a metric other than Occurrences, the manual order gets reordered by the metric. So close but so far.
Yes, I do! I didn't know that was there, that's helpful for other analyses, thanks.
However, that just sorts alphabetically, which isn't what I'm after in this example. This example would still require a full manual sorting option, which could be as simple as the order I drop dimension items into the table.
when you drop just single items, do you have an option on the header row (of the dimension) to manually sort? in your screenshot next to "Revenue Range" there should appear a sort arrow after the first few items (maybe only appears when you hover over the header field)
That would be useful if I could manually drop them in, but when I try that, the metric sorting still takes precedence.
I tried dropping in dimension items one at a time; selecting in order, then dropping in all together; and doing that all with and without metrics present. I can't get the order to hold any way I do it.
Let me know if I'm doing something wrong, details if you can.