Forum Discussion

ovetteabejuela's avatar
ovetteabejuela
Icon for Impactful Individual rankImpactful Individual
9 years ago
Solved

Rates: Daily Target is Monthly Target (Target change Monthly)

Hi Community!   I would like to know how I can do this properly, the image below should show what my goal is:   Basically I dont want the target to end up to the sum of daily targets. Since this ...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Could you set the default sumarisation on the field to me something other than SUM (eg, MAX, MIN, AVERAGE) ?

  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    ovetteabejuela

     

    As Phil_Seamark said, to have the target "fixed" on all level, you just need to change the aggregation type for this field in either visual level or Modeling.

     

     

     

    Regards,

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Could you set the default sumarisation on the field to me something other than SUM (eg, MAX, MIN, AVERAGE) ?