Hi All,
I am trying to get Calculated aggregated Dimension in a chart
I have a below formula, Could someone please help in getting it right? currently its only showing above target attribute and nothing else.
=If(
Aggr(Sum({<Activity_Status={'Submitted'},Is_Target_Account={'Yes'}>}Actual),[%Account_ID])
>
Aggr(Sum({<Activity_Status={'Submitted'},Is_Target_Account={'Yes'}>}Target),[%Account_ID])
, 'Above Target',
If(
Aggr(Sum({<Activity_Status={'Submitted'},Is_Target_Account={'Yes'}>}Actual),[%Account_ID])
=
Aggr(Sum({<Activity_Status={'Submitted'},Is_Target_Account={'Yes'}>}Target),[%Account_ID])
,'On Target',
If(
Aggr(Sum({<Activity_Status={'Submitted'},Is_Target_Account={'Yes'}>}Actual),[%Account_ID])
<
Aggr(Sum({<Activity_Status={'Submitted'},Is_Target_Account={'Yes'}>}Target),[%Account_ID])
,'Below Target',
If(
Aggr(Sum({<Activity_Status={'Submitted'},Is_Target_Account={'Yes'}>}Actual),[%Account_ID])
=0,
'No Calls'
))))
