8 Replies Latest reply on Sep 28, 2018 1:03 AM by Ashes Limbu

    URGENT help! - Total & Subtotal incorrect while using show/hide filter

    Ashes Limbu

      Hi Everyone!

       

      Need your expertise help! Attached are the workbook and screenshots.

       

      Basically when using the show/hide parameter we created other day , subtotal or total shows value for the entire hidden + shown rows.

       

      Requirement is to show total/subtotal for only the visible rows.

      1. i.e only 4 instead of 14.

        with show hide filter.jpg

      If I remove the show/hide calculation from the report then total/sub totals are correct.

       

      with out show hide filter.jpg

       

      Message was edited by: Ashes Limbu Hi Everyone i have reattached the workbook. Regards Ashes Limbu