Sort dynrange by value from one palo.datac

    Sort dynrange by value from one palo.datac


    is it possible to sort a dynarange containing several palo.datac´s by value from just one palo.datac?

    I´ve got a timeline (see attachments) with palo.datac functions (blue cells).
    Now I´d like to sort the whole table by january´s values. The expected outcome should look like attachment II.

    Is there any possibility to sort the whole area? Or any suggestion how to achieve the expected outcome?

    Thanks in advance for your help.
    • Example_Sort_expected_outcome.png

      8.54 kB, 853×153, viewed 65 times
    • 2017-09-01 14_11_12-Jedox Web.png

      2.05 kB, 609×59, viewed 63 times
    If your DynaRange source is a subset, you can sort the subset by values returned by a query that you define in the data tab. You can set variables in this tab, so that this query has the same links to spreadsheet cells as your DATA functions in the DynaRange area.