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. 
Niels Thomsen 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?
Brian Sandfeld 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
Comments
2 comments