Using RSUM with with dashboard filters
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 RSu...
Forum Discussion
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:
- Switch the filter behavior from Slice to Highlight - this way selected months will be highlighted and RSUM will be calculated properly, however all months will still be displayed on a widget
- Calculate RSUM on the model level with help of a custom table and then display it as is in widget
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
