Dynarange & Subset with multiple restriction

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • Dynarange & Subset with multiple restriction

    Hi guys,

    Here is my problem.

    I have a cube with the following dimensions : A (elements : a1, ..., aN) & B (elements : b1, ..., bN)

    I want to do a dynarange capable of getting informations from this cube where (a1,b1)=1 AND (a2,b2) = 2 (for ex)

    I know I can either have the first or the second condition in the DATA tab of the subset. But how can I have both ?

    Please don't tell me I have to do a dynarange capable of filtering on (a1,b1)=1 and another one with (a2,b2) = 2.............. :)

    Thanks in advance for your advices.

  • Hi trall,

    you can try the following:

    1/ code a macro where you define 2 arrays populated by 2 palo_subset formulas that correspond to your conditions
    2/ intersect both arrays
    3/ return the intersection

    then instead of using a subset in the definition of your dynarange, use your custom macro.

    I believe that it should do the trick

    cheers
    laloune

    Post hoc, non est propter hoc