title: Google Data Studio, how to get a sum of all Max or Min values
body: <p>I am working with a data set where i have to get Min or Max for different text fields. My dataset can have thousands of rows so below is a simpler example. So I have 3 categories having multiple values and I can put this dataset in GDS to build a table where I select Category as dimention and Value as Max(Value) in metric.
  Now I need to see the sum of all those values too. But like the pivot table in excel, the subtotal in GDS shows the Max out of all the max listed above. So instead of 65, it shows 30 in GDS. Is there a way I can get it to show the sum?</p>
  <p><a href="https://i.stack.imgur.com/sab0f.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sab0f.png" alt="Category" /></a></p>