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.  



  • 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. 

    That is exactly what I need


Please sign in to leave a comment.

Didn't find what you were looking for?

New post