Cumul Value while Selection

[beck_bakytbek]

Hi Folks,

i got the Question: can i change my normal values while the selection into cumulative values,

i have 2 fields: 

Month, Sales

Jan, 5

Feb, 3

March, 3

please see the screenshots, i have the bar-Diagramm with normal value and if i select my filter Moth: Jan, Feb, March, so i want to have to Change my normal values within Diagramm into cumulative values.

Does anybody have any ideas ?

Thanks a lot

Beck

[Anil_Babu_Samineni]

Perhaps this

If(GetSelectedCount(Month)>0, RangeSum(Above(TOTAL Sum({<Month={">=$(=Min(Month))<=$(=Max(Month))"}>} Sales), 0, Rowno(TOTAL)), Sum(Sales))

[Kushal_Chawda]

Make sure that your month field is in proper month format. You can check this by taking this field in listbox in which if it is right aligned means it is in proper format if it is left aligned means it is in text format.

If it is in text format you need to convert it in proper month format like below

date(Date#(Month,'MMM'),'MMM') as MONTH

Now you can create a chart with Dimension MONTH and expression like below

=if(GetSelectedCount(MONTH)>0,
RangeSum(Above(sum(Sales),0,RowNo())),sum(Sales))

[beck_bakytbek]

Hi Anil Babu,

thanks a lot for your responce,  i implemented it , but it does  not work

[beck_bakytbek]

Hello Kush,

thanks a lot for your responce, i implemented it, but it does not work,

my issue: if i select last month, i want to see the cumulative value from all moths, but if i select last month i see only the value of last month.

do you have any idea?

thanks a lot

[Kashyap_R]

Hi

The values will not change if u use it in the backend but if u use it in front end the values depend on previous value so the value will get changed and retains its old value.

Try using this expression in the backend

RangeSum(peek(CumulaiveSales) , Sales) as CumulaiveSales

Hope this helps

Thanks

[Kushal_Chawda]

send sample file. If you have implemented the steps as I have described, I don't think the should be any problem.

What is the dimension and expression you are using?

[beck_bakytbek]

Hi Kush,

thanks a lot for your responce and help. i attached the example with problem-issue

Thanks a lot