The chart change should not change when I change the pivot setting

[#1]

Dear

please to se the attachement.

Thanks

[oknotsen]

Hi,

Can you please describe what you want and what you tried to do to achieve that, as I am having a hard time trying to understand the attached Word document.

Please post the expression you are using and tell me what you think is wrong with it.

Thanks.

[#3]

Hi

thanks for the kind reply, sorry to be not so clear

I review the doc , please to see if now you can understand better the issue

many thanks

[Anonymous]

Hi

I must admit that I have not studied your document in detail but at a first glimpse you could try writing this.

rangesum(above(Sum({1<Year = {'2014'},OrderType=, AlsisStatus = {'G','J'}>}CountOrder), 0, Rowno())) 

Again I have not studied this in detail but try this expression, I might help you in the right direction.

[#5]

Hi

just for your info  AlsisStatus (database variable name )=OrderType (how we show AlsisStatus variable to user)

so "unfortunatelly" it is already in expression

please why "1<"?

rangesum(above(Sum({1<Year ....

thanks

[Anonymous · Accepted solution]

Hi

The 1 will dissregard the current selection see example below.

sum( {1<Region= {US} >} Sales ) returns the sales for region US disregarding the current selection

[#7]

Many thanks!