cancel
Showing results for
Did you mean:
Creator

## Cummulative in Pivot table

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

Best regards.

1 Solution

Accepted Solutions

May be use Set analysis

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

Or

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
4 Replies

May be use Set analysis

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

Or

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Creator
Author

Thank you

MVP

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

Creator
Author

OK, I mark his response as correct

Community Browser