5 Replies Latest reply on Nov 1, 2018 5:40 PM by Shinichiro Murakami

    A fixed sum across dimensions

    Josh Ciszek

      Hi everyone...

       

      Based on the picture below...I need a row that shows the sumof the 3 columns circled.  I used the FIXED LOD to create the fixed sum of all clients ("Total Clients - All Time") and that one stays fixed no matter what filters I apply...which is correct.  But I need another row that shows the total clients that are used in the filter.  I've highlighted in red what I need.  Basically, I need "Total Clients Assessed" but not broken out by the columns.

       

      I've attached the workbook...

      Picture1.png