Subtotal of visible rows
Is there a way to calculate the subtotal of the visible rows and show the subtotal under a certain dimension.
In the below example I will like to show the correct subtotal of each column for every person. All Id's (Customers) not having an overdue amount is hidden and the current subtotal is wrong. 
0
Comments
Hi Brian
To create a total of visible rows (as a calculated row) - the syntax would be sum(0,all(v),0).
But you mention subtotals - so I guess the problem is more complex?
Hi Niels
Thanks for the answer. It does solve some of it. However, I found this Targit youtube video explaining the solution. https://www.youtube.com/watch?v=a0XvfCn1spY
That is exactly what I need
Please sign in to leave a comment.