Skip to main content
Announcements
Discover what’s possible with embedded analytics! March 6, 10 AM ET SIGN UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
byrnel0586
Creator
Creator

Aggr to show overall county values

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.

2 Replies
byrnel0586
Creator
Creator
Author

I was able to get this to work

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

vishsaggi
Champion III
Champion III

may be you can also try like

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