Forum Discussion

MilanAXVII's avatar
MilanAXVII
Helper I
8 years ago

Cumulative Sum

hi 

i need help.

i have data of 2017 and beginning of 2018

i want to do a cumulative sum and put this in a graph. 

until here all is right. but I want also filter my data, for example between the 5/01/2018 and 12/01/2018. 

and i want this sum begin from 5/01/2018 by 0 and not the cumulative number since 01/01/2017

 

i'd like to put a 0  ât the beginning instead of a 18

 

Someone can help me

 

Need Help

2 Replies

    • MilanAXVII's avatar
      MilanAXVII
      Helper I
      8 years ago
      **bleep** KNST = IF(CALCULATE([PeriodSelected]; ALLSELECTED(Table_owssvr)) = "Year"; [**bleep** KNST Year]; IF(CALCULATE([PeriodSelected]; ALLSELECTED(Table_owssvr))="month";[**bleep** KNST month];[**bleep** KNST day]))
      **bleep** KNST day = CALCULATE([count KNqual ST]; FILTER(ALL(Table_owssvr);Table_owssvr[date] <= MAX(Table_owssvr[date])))


**bleep** KNST month = CALCULATE([count KNqual ST]; FILTER(ALL(Table_owssvr);Table_owssvr[month] = MAX(Table_owssvr[month])))

**bleep** KNST Year = CALCULATE([count KNqual ST];FILTER(ALL(Table_owssvr);Table_owssvr[date] <= MAX(Table_owssvr[date]) && Table_owssvr[year] = MAX(Table_owssvr[year])))
      PeriodSelected = IF([NumberOfMonths] = 1; "Month"; "Year")

      That's all.

      but i'm new so i take formula here and formula there. it's a weak construction...