Selection in set analysis

Mon, 23 Feb 2015 10:32:21 GMT

I have a set analys that works very good but I would have a new chart on the same sheet that show another

product without choosing it from a field box. I have the set in an variable and have tried to extend it but it doesn´t work.

PeriodID = {$(=Max(PeriodID))},{<MaterialNr={D102328}>},
Year = ,
Quarter= ,
Month= ,
Period=

this expands the variable:

Sum({$<$(DNEYE)>} [DebPris]/100)

And this is what I like to achieve:

I have tried a lot of different things to get the value only for this MaterialNr

kindly

Håkan

Re: Selection in set analysis

MK_QSL — Mon, 23 Feb 2015 10:34:47 GMT

PeriodID = {$(=Max(PeriodID))},

MaterialNr={'D102328'},

Year = ,

Quarter= ,

Month= ,

Period=

Mon, 23 Feb 2015 10:46:12 GMT

Thanks for a very fas response.

Håkan