Aggr to show overall county values

[byrnel0586]

Hi all,

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.

Any help is appreciated.

[byrnel0586]

I was able to get this to work

=Aggr((SUM({<Year, Month,PCP_ID=,VEND_ID=,PCPwTitle=>}DENOMINATOR)),County,_MeasureYearKey)

[vishsaggi]

may be you can also try like

= SUM(TOTAL <County,_MeasureYearKey> {<Year, Month, PCP_ID=, VEND_ID=, PCPwTitle= >} DENOMINATOR)