
1. Re: LOD Calculation to Sum Certain Values Not Found on Filtered Tab/Column
Jenell Green Jul 27, 2018 1:35 PM (in response to Lindon Belshe)Hi Lindon,
To clarify, it looks like the receiving number of records for Group D is 154, not 145?
You can create a duplicate of the receiving field, I called it "Receiving  denominator" in my example attached. Add this field to your filters, and check 'add to context'. Uncheck any group that you do not want in your numerator nor denominator. Then bring your regular Receiving field also into filters, and uncheck just Group D.Create another table calc called denominator with the value {SUM([Number of Records])}  This gives you the number of records in the whole window, not just the context. Since the regular receiving field is not set to context, Group D values will still come through.
Create an additional calculated field for the Percent of Total: SUM([Number of Records])/SUM([denominator])
This allows your numerator to only bring in any value in either of the two filters, while the bottom of the calculation is only values in your "receiving" filter, completely irrelevant of your "receiving denominator" filter.
This is a bit hacky! But hopefully it at least steers you in the right direction
Jenell

Example_jgreen.twbx 34.3 KB


2. Re: LOD Calculation to Sum Certain Values Not Found on Filtered Tab/Column
Lindon Belshe Jul 27, 2018 1:44 PM (in response to Jenell Green)Hi Jenell,
To your clarify question, exactly. The denominator needs to be the sum of the first three groups' receiving and group D's sending. Otherwise, I would use a global filter to filter our groups AD and then a nonglobal filter or just hide Group D. Basically, denominator in the % of Total calculation would be the sum of the following...

3. Re: LOD Calculation to Sum Certain Values Not Found on Filtered Tab/Column
Gerardo Varela Jul 27, 2018 1:47 PM (in response to Lindon Belshe)Hi Lindon,
See if the attached is what you are after. If it is and you need me to explain anything just let me know.
Regards,
Gerardo

Example277082gv.twbx 42.2 KB
