Evaluating "sets" in the context of a dimension (Set analysis priblem?)

[#1]

Hi,

i've a problem with set analysis. I want calculate sum values about a PDV (that i select with variable) for only those Articoli that are in common with the PDV present in row: on the left there is tha data base, on top we have the variable where select the PDV target, on center we have the graph were i want the calculationthx for support

[#2]

i resolve in a static way:

if(PDV='a',sum(total {$<PDV = {$(=v_PDV)},Articolo = p({$<PDV={'a'}>} Articolo)>} Prezzo),

    if(PDV='b',sum(total {$<PDV = {$(=v_PDV)},Articolo = p({$<PDV={'b'}>} Articolo)>} Prezzo),

        if(PDV='c',sum(total {$<PDV = {$(=v_PDV)},Articolo = p({$<PDV={'c'}>} Articolo)>} Prezzo),

            if(PDV='d',sum(total {$<PDV = {$(=v_PDV)},Articolo = p({$<PDV={'d'}>} Articolo)>} Prezzo)))))

but i want something dynamic, something like this:

sum(total {$<PDV = {$(=v_PDV)},Articolo = p({$<PDV={???}>} Articolo)>} Prezzo)

where ??? i want the value of PDV corresponding the row chart

[maxgro]

Evaluating "sets" in the context of a dimension

[#4 · Accepted solution]

Hi,

i've already read that post. But we resolve like this:

sum(aggr(nodistinct sum({$<PDV={$(v_PDV)}>}Prezzo), Articolo))

thx anyway