I need help in using a calculated column for getting the totals of a column that contains data for each item entered.
I have a view with group by columns.
Group by Column A and Group by Column B
And a Column C with number values. Each column contains a value for each record. Name A in Column A group contains 20 (items), Name B in Column B contains 30 (items), ect...
What I need help with is to figure out a way to sum the data in Column C and show that in each set of groups.
I need the sum of Items for Name A and Name B. In this example it should be 50 (items in total).