Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculating Summary

I am wanting to be able to calculate a measure at the most detailed level, but also have that same meausre calculate on a group that the most detail belongs to.

 

Well Master Table

  • Engineering Field
    • Well

Each well is part of an Engineering Field. 

All data is recorded at the well level.  I want be able to see a total cost for the well and a total cost for the Engineering Field.  I would be summarizing a measure called "Total Fixed Cost"

 

Ultimately, I will use switch to use the Well calculation if there is 12 monts of data, if not use the Engineering Field calculation.

 

Any thoughts?

Need Help

2 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous please share sample data with expected result. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      So many wells belong to an engineering field.  We want to see the wells specific calculation of a given measure and the same measure for the Engineering field the well belongs to.  

       

      Below is a screenshot of the well table which is tied to our fact table.

       

      So many wells belong to an engineering field.  We want to see the wells specific calculation of a given measure and the same measure for the Engineering field the well belongs to.  parry2k