10 Replies Latest reply on May 11, 2018 1:52 AM by 관형 김

    How to Calculrate S-Total  by using Sumifs  and Display Searched Datas

    관형 김

      Hi.

      I allways  thx about your supports and help

       

      I already and almost resolved this qeustions

      But I can't operate properly.. and explan my hope clearly

      because I'm not good at writing english..

       

      So. I changed My QnA litte... and Excel files..

       

      I Want to and know..

       

      1. Calculrate S-Total

          I used Sumifs in Excel for Bank   and Total is Running_sum(all)

       

      2. When I Search "D/L"    Find Matched Datas such as upper tables(already calculrated or not.. it dosen't matter) and Show Matched datas

      Some time  ... Only one of the data  .. or  many datas

       

       

      TABLEAU QNA.JPG