5 Replies Latest reply on Aug 9, 2016 5:13 PM by Shinichiro Murakami

    Don't want to duplicate calculated field across multiple workbooks

    Joe Milo

      Hi- I am creating a simple calculated field, just a percent of total records. I need to see 6 different percents of total, based on asset class. I have a worksheet for each asset class, so 6 different worksheets, and the only difference between the sheets is the filter on asset class that I am applying. Because each of the worksheets is going to be on 1 dashboard, I need to make the 6 worksheets 6 different colors.

       

      I would like to use the same calculated field across all 6 worksheets, but I can't do that because of the need for different colors, so I'm having to create 6 different calculated fields, all with the same formula, just to be able to assign a different color.

       

      Is there a way around this?