Calculate Standard Deviation Price for last not selected dimensions

[hhajjali]

Hello,

In my application I have calculated the price deviation as follow and it is working fine, it calculate the deviation taking into account the ITERATION I have selected.

Stdev(aggr(Sum([PRICE])/Sum({<[CATEGORY]={"1"}>}[NB ITEMS]),ITERATION))

The table bellow resume my DATA:

Iteration	NB ITEMS	CATEGORY	PRICE
IT1	5	2	1000
IT1	4	1	3500
IT2	3	1	350
IT3	9	1	1000
IT4	11	1	4000
IT5	4	1	3000

Here is my problem, I display always only 3 iteration in my report.  I need to calculate 2 KPI:

- stdev for the 3 selected iterations (which is done) ex: IT5,IT4,IT3

- stedv for the before last 3 selected iteration: ex: IT4,IT3,IT2

My goal is to display both stedv to tell if the stdev was better before or no.

Thanks for your help.

[petter · Accepted solution]

Is it something like this you had in mind?

[hhajjali]

Thanks a lot for your help, combining range stdev and formulas in set analysis is the solution.

[petter]

you're welcome