10 Replies Latest reply on Aug 10, 2016 12:04 PM by Ben Page

    Help with level of detail calculation

    Patrick T



      I have a dashboard in which sheet1 acts as a filter upon sheet2. Sheet2 has some percentage calculations, and whenever I use sheet1 to filter sheet 2 it changes the percentages. I would like the percentages to stay the same, when the filter is applied. I have attempted doing this with level of detail expressions, but have thus far had no luck. Any suggestions would be more than welcome. I have attached a copy of an example workbook. Thanks