Issue in subtotal with Smart filters using user list
I have created a smart filter using the user list. The filters are working fine.
The issue is in the sub-total, is there a way to get the sub-total in an optimized manner.
Currently to get the subtotals right, I need to use user list as a dimension in my module and use an If formula, eg. if the filter is true than take value else 0, but the issue is that I need to include my user dimension which is increasing the size of the module.
Any suggestions if correct subtotals can be calculated based on the filter without using the user dimension in the module.