6 Replies Latest reply on Jun 25, 2012 4:08 PM by Jess Lee

    sum of window_min?

    Jess Lee

      Hello,

       

      Can anyone please help me find min data group by top id and middle id ? Then i would like to sum all min data to get final result.  The final result will show only $137.59 nothing else.  Many thanks

       

      Data
      TOP IDMIDDLE IDDETAIL IDAmtNeed to create a Tableau calculated field to have below results
      10029010410013010312050215412$25.46 $25.46
      10029011410013010412050215413$7.57 $7.57
      1002901531001520681206081802$50.00
      10029015310015206812061205115$24.96 $24.96
      1002903531001300631205020001$7.81
      10029035310013006312050315410$7.81 $7.81
      1002903571001300641205020002$12.45
      1002903571001300641205031602$9.34 $9.34
      1002903641001300651205020004$62.45
      1002903641001300651205031609$62.45 $62.45