I have a straight table that shows summed 'ELIG' totals w/ PCP/Vendor dimensions, but within the same chart I am needing to show the overall county's 'ELIG' values, regardless of PCP/Vendor selection. I have tried set analysis and TOTAL qualifiers to get the result, but am having no luck.
Below are the expressions I am using
'ELIG': Aggr(sum(ELIGIBLE),PCP_ID,_MeasureYearKey) <-- working as I need
'County ELIG': Aggr(sum(ELIGIBLE),County,_MeasureYearKey) <-- giving me values based on the pcp/vendor selection instead of the county's overall sum.