My dashboard shows the value and running sum of the value for each month. When I select a date range in the dashboard date filter I want to the pivot to show the selected period however the first RSum Value should show the running sum including all previous months.
So for this example, when I filter to months between 05/2023 and 10/2023 I want to see 1,347,463 return for 05/2023.
Any suggestions? intapiuser
Hello,
You can use the ALL() function in the formula to achieve your current goal.
Here is the example : (Rsum([Total Cost]),ALL([Years in Date]))
Kind regards.
Indeed this seems to be working here! Here is another example showing week 22 RSUM with All() function starting with 97.65
Hi GSSC
I don't think this is possible as RSUM specifically calculates the visible/available data in the same order, meaning if values are excluded from the widget with filter - those values cannot be used in RSUM calculation.
I would suggest 2 ways around this:
Thanks OlehChudiiovych for the response. Would it be possible to achieve this in the widget by using the advanced filters? I've been trying to get this working having no luck
