3 Replies Latest reply: Feb 10, 2015 8:43 AM by Paolo Panizza

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

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

• ###### Re: Evaluating "sets" in the context of a dimension (Set analysis priblem?)

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

• ###### Re: Evaluating "sets" in the context of a dimension (Set analysis priblem?)

Hi,