Show single overall average value for a selected Dim

[regowins]

Hi,
I currently have a chart that shows the count of notifications  by territory and the overall avg notification count by  territories. However, if I select 1 or 2 territories I only want to see their counts and the overall avg.  I don't want the overall avg for the unselected territory. I want to see only one territory(count and overall territory avg) in my  chart.

Thanks!

no selections

Territory	Count([Note#])	Count   ({<Territory=>}  TOTAL   [Notification #])	Count   ({<Territory=>} DISTINCT TOTAL Territory)	Overall Territory Avg
	720	720	12	60
Z011	72	720	12	60
Z012	67	720	12	60
Z013	30	720	12	60
Z014	56	720	12	60
Z015	112	720	12	60
Z016	57	720	12	60
Z017	64	720	12	60
Z018	44	720	12	60
Z019	47	720	12	60
Z020	92	720	12	60
Z021	49	720	12	60
Z022	30	720	12	60

Currently if I select only Z014

Territory	Count([Note#])	Count   ({<Territory=>}  TOTAL   [Notification #])	Count   ({<Territory=>} DISTINCT TOTAL Territory)	Territory Avg
	0	720	12	60
Z011	0	720	12	60
Z012	0	720	12	60
Z013	0	720	12	60
Z014	56	720	12	60
Z015	0	720	12	60
Z016	0	720	12	60
Z017	0	720	12	60
Z018	0	720	12	60
Z019	0	720	12	60
Z020	0	720	12	60
Z021	0	720	12	60
Z022	0	720	12	60

I would like it to be like this  Z014

Territory	Count([Not#])			Territory Avg
		720	12	60
Z014	56	720	12	60

[its_anandrjs]

Remove Territory= from all expression.

[swuehl]

Could you post a small sample application? Seems to work in my attached sample (not using your data model, since I don't know it).

[its_anandrjs]

From any one expression   like 

Count ({<Territory=>}  TOTAL [Notification #])  in place of this use

Count ( TOTAL [Notification #]) because by using Territory= it will bypass the field selection.

[regowins]

Interesting it works in  your test app. At least I know I am on the write path. Not sure if I can post the sample app though.

Thanks!

[regowins]

It did not work.  I used Territory =  becuase I want to bypass the selection for the overall avg so it stays constant, regardless of which territory selection I pick.

Thanks for the help.

[#7]

Just remove {<Territory=>}  and  TOTAL from your expressions.

{<Territory=>} ignores any selection in Territory field and TOTAL ignores chart dimensions. What I understand from your question, you don't need both of them.