Hi,
I need help with a calculation. I have a group that I am filtering out with a group selection formula.
I am using a running total that resets at the group level and I get the right count in the group footer. I know I can't use the running total in the header.
Is there a workaround to display the distinctcount in the header. If I use a sum I get the number of all records ignoring the filter.
I hope it's not confusing and any help is appreciated.
Thanks
I need help with a calculation. I have a group that I am filtering out with a group selection formula.
I am using a running total that resets at the group level and I get the right count in the group footer. I know I can't use the running total in the header.
Is there a workaround to display the distinctcount in the header. If I use a sum I get the number of all records ignoring the filter.
I hope it's not confusing and any help is appreciated.
Thanks