Forum Discussion

nhodges's avatar
nhodges
Helper I
2 years ago
Solved

Combining like measures for different tables

I have 5 tables all with their own seperate Total Revenue Calculation formulas. In each table I have created a Total Revenue Measure. Now I would like one big table that shows all the Total revenue m...
Need Help
  • isjoycewang's avatar
    isjoycewang
    2 years ago

    Hi nhodges ,

     

    Is this what you want? Define the row header first, and then you can define which measure to use in each row.

     

    I have a dummy file for reference, please replace the table and measure to your own. Thanks.

    Exercise File

     

isjoycewang's avatar
isjoycewang
Solution Supplier
2 years ago

Hi nhodges ,

 

Is this what you want? Define the row header first, and then you can define which measure to use in each row.

 

I have a dummy file for reference, please replace the table and measure to your own. Thanks.

Exercise File

 

  • nhodges's avatar
    nhodges
    Helper I
    2 years ago

    One more question: Is this added as a table formula, or measure? Seems like I am building a new table then putting this as the formula? Is that correct?

     

    This looks great, will give this a try!

    Thank you for the help!

    • nhodges's avatar
      nhodges
      Helper I
      2 years ago

      I already have a CALENDAR table that they all connect to