Forum Discussion

lmondavi's avatar
lmondavi
Frequent Visitor
8 years ago
Solved

Creating a measure to sum different columns based on row value

Hi, I have a Funnel table with 3 different $ value columns (SM_M1, SM_M2, and SM_M3). I have an employee table which is unrelated to the Funnel table. I want to create one measure that will sum one o...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    You may refer to my solution here.

     

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

Share your data and show the expected result.

lmondavi's avatar
lmondavi
Frequent Visitor
8 years ago

Thanks, here is the data with expected result

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    You may refer to my solution here.

     

    Hope this helps.

     

    • lmondavi's avatar
      lmondavi
      Frequent Visitor
      8 years ago

      Thank you so much!

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        8 years ago

        You are welcome.