8 Replies Latest reply on May 8, 2018 7:56 AM by Gerardo Varela

    Is it possible to exclude specific values from a grand total but still show those values in the detail?

    Dennis DeSantis

      Hi,

       

      I'm trying to create a table that shows scores over a rolling 13 month timeframe, but the grand total column aggregates only the YTD data (excludes any records where the date dimension doesn't occur in current year).  Up to this point, I've had to fudge the visualization by creating two separate worksheets (one showing the monthly scores for rolling 13 month timeframe and another showing the YTD total) then put them together in the dashboard to make it look like one table.  This is obviously not ideal for several reasons.  I attached a workbook with a simplified example of what I'm currently doing to get the visualization/calculations that I want.  Is there a way to do this without having to use two separate worksheets?  Thank you!

       

      -Dennis