Forum Discussion

JeffH's avatar
JeffH
Icon for Helper I rankHelper I
6 years ago
Solved

Help

Hello,    I have data given to me in the following format. Basically it is truckloads with mulistops on them. The data shows the load ID but has the total load cost on each stop row. I need to show...
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    Does this work?

    =SUMX(VALUES(Data[CHRNumber]),[Load Cost])

JeffH's avatar
JeffH
Icon for Helper I rankHelper I
6 years ago

Thank You, that did the trick. However I should have mentioned that I need to be able to total my load costs. Using the MIN function just shows the MIN load cost rather than the totals. Is there a way to total this? 

 

 

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

Hi,

Does this work?

=SUMX(VALUES(Data[CHRNumber]),[Load Cost])