accumulation in chart problem

[#1]

Hello,

I am looking very long time now for an answer to my question but I can't find anything so I need your help.

I have many charts which I want to  put the accumulation sum. The problem is that the accumulation sum changes with the differents filter selections.

I have 2 dimentions : Week and Product and NbVendus on expression.

For exemple:

If nothing is selected we have on week 0 for Product 1 => 1058828 (which is the accumulated sum of weeks (-25, -17, -9, - 8...0)

But if I select the weeks (-3,-2-1,0) for exemple I have 858376 for Product 1.

How I could disable the week selection in the calculation?

PFA file test

thank u

[juleshartley]

Have you tried using set analysis? There are many threads about how to use it, but you can remove selections easily using it.

For example:

Sum (

          {$

                    <

                              Semaine={"*"}//Remove semaine

                    >

          }

Nbvendus

)

See attached file. Note - this only removes week if you select it. If you want it to only happen under certain conditions then you will need to add an 'if' clause or similar.

[juleshartley]

Sorry - can't seem to attach file to a reply...