Aggregate data based on dimesions

kishoreanimi
kishoreanimi
in Modeling
Target module.PNG
Source module 1..PNG

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

Answers

  • BrunoRodriguez
    BrunoRodriguez

    hello @kishoreanimi ,


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

    Cheers!

    Kind regards,

    Bruno Rodriguez

  • HimanshuRaj
    HimanshuRaj

    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

    Cheers!

Categories