Is there a way to hide/exclude values in a table card's subtotal? I want to do this because a few of my metrics do not make sense summed up
For the fields you want to hide from the subtotal, click on the column name where you added it to the table. Choose "Subtotal/Total" and the click "Hide subtotal".. see below:
This will keep it from summing up values that it shouldn't.
Let me know if you need any other help.
**Please mark "Accept as Solution" if this post solves your problem**Say "Thanks" by clicking the thumbs up if this post helped you.
Hi ValiantSpur, I want to hide only a few columns, not all
This is done an a per column basis, see the screenshot below:
To hide the subtotal for the date column, i can click on the Date field at the top of the visual like so:
After choosing Subtotal/Total, and Hide Subtotal, I'm left with the following: