Aggregate data based on dimesions


In source module i want to select the Defalult and alterenative is input. based on that target module percentage should calculate(if it is bdefault the 1(100% ) else balank) . now i am getting error mismatched levels how to go about it


  • hello @kishoreanimi ,

    Can you share the format of the line items in "Input allocation Method"?


    Kind regards,

    Bruno Rodriguez

  • Hi @kishoreanimi

    You can use IF ELSE in your formula to achieve what you need.

    Before that, you also need to check that how is "Fair trade eligible" dimension in your source module going to be mapped with "Producing Area" & "Calendar week" dimension in your target module