Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Is it something like this you had in mind?
Is it something like this you had in mind?
Thanks a lot for your help, combining range stdev and formulas in set analysis is the solution.
you're welcome