Cummulative in Pivot table

[jozisvk11]

Good morning, I have a problem with cummulative in pivot table. My actual table is:

Financial mouth               Revenues 2017          Revenues 2016          Revenues 2017(cummulative)

     Jan                                   20000                         25000                         20000    

     Feb                                   30000                         28000                         50000

     Mar (today 3.3. 2017)          2000                          35000                         52000

     Apr                                        0                            37000                         52000

     Mai                                        0                           33000                          52000

     Jun                                        0                           40000                          52000

     Jul                                         0                           30000                          52000

.

.

I need to make, that cummulative Revenues 2017 will be calculated only to today´s date (mounth MARCH). So the result table should be:

Financial mouth               Revenues 2017          Revenues 2016          Revenues 2017(cummulative)

     Jan                                   20000                         25000                         20000    

     Feb                                   30000                         28000                         50000

     Mar (today 3.3. 2017)          2000                          35000                         52000

     Apr                                        0                            37000                         0

     Mai                                       0                            33000                         0

     Jun                                       0                            40000                         0

     Jul                                        0                            30000                         0

   Thank you for your helping.

Best regards.                 

[Anil_Babu_Samineni · Accepted solution]

May be use Set analysis

Sum({<DateField = {'<= Today()'}>} [Revenues 2017(cummulative)])

Or

If(DateField <= Today(), Sum([Revenues 2017(cummulative)]), 0)

[jozisvk11]

Thank you

[sunny_talwar]

If your issue has been resolved, please close the thread by marking Anil's response as correct and or helpful. If you still have questions, please elaborate as to what you are looking for.

Best,

Sunny

[jozisvk11]

OK, I mark his response as correct