Hello,
I have an InfoPath form that is being used just to display information. It is connected to a SharePoint list that has a Category column, SubCategories column and Maturity(number) columns.
I have a dropdown that users use to select the Category they want to view and then a repeating table will display ONLY the SubCategories and Maturity numbers that have the corresponding Category (I used a formatting rule on the repeating table to achieve this).
Now they would like me to be able to sum the Maturity column - but they would like it to be if a Category has not been selected, it sums everything - once a Category has been selected and the repeating table have been filtered down, the sum should only sum the displaying Maturity numbers.
Adding a field with just the SUM(Maturity field from the data connection) just sums all the numbers and it never changes when the repeating table is filtered.
Can this be done somehow?
Thanks!