Forum Discussion

Kurtle's avatar
Kurtle
Helper II
6 years ago

Running Cumulative Percent

Hi team,    I am trying to get a running percent using a meaure here. What I would like to do is get a cumulative percent of Gross Gath Gas when sorted by GOR. Both GOR and Gross Gath Gas are measu...
Need Help
v-easonf-msft's avatar
v-easonf-msft
Community Support
6 years ago

Hi  , Kurtle 

Sorry for that I am not sure what you want.
Isn't 6.25 your result？Or you want to show it as a percentage?

 

If it is the former, I hope you can show the results you want .It will be better to understand your problem.

 

If it is the latter, you can use the percentage format button directly for measure as below:

 

 

Best Regards,
Community Support Team _ Eason

Kurtle's avatar
Kurtle
Helper II
6 years ago

v-easonf-msft 

Sorry for the poor explanation... I would like to have a cumulitive percentage of the Gas when the table is sorted in descending order by GOR. See the picture below. Normally I would not have a problem doing this with a date but the GOR column is a Measure and all rows are from the same week. So I am unsure what to use as a index column to follow something like such as this.