1 Reply Latest reply on Jul 12, 2018 9:01 AM by Shinichiro Murakami

    table sum calculation with 2 criteria

    Arun  Kumar

      Attached the file for your reference. On the Transaction type i wanted only the first "BIOH" to show for table calculation and the rest to not show up for table calculation. Add always "BIOH" will the 1st line.

       

      So the results should be as shown below. when i do rank (index() function) it still does the table calculation for even the filtered rows.

       

      Message was edited by: Arun  Kumar