Show Grandtotals and Subtotals of only visible values
In this table I added a visibility agent, so the totals are kind of wrong now.
This blog entry shows how we can add a calculated row that shows all grandtotals of only visible values: Visibility Modifiers – TARGIT Community
It would be great if we can show only the visible grand totals and subtotals with the default function: 
My idea is to click on the button once to disable the subtotal and click twice to get only the visible values...
5
Comments
Hallo Ole Dyring
I have the same issue again, do you have an idea?
This is an issue for a lot of our customers.
Hi Marlene,
I think I have described a work-around to this problem in quite a few posts already, but couldn't find them. So now I have made an article for the work-around.
https://community.targit.com/hc/en-us/articles/17086736762780-Calculate-Totals-and-Subtotals-for-visible-data
Still, it is a valid feature request - to make a built-in feature that can do this.
BR / Ole
(Note: Duplicate request here: https://community.targit.com/hc/en-us/community/posts/7331977851165-Standard-Totals-and-Subtotals-based-on-visible-data)
Please sign in to leave a comment.