6 Replies Latest reply on Aug 1, 2018 9:25 AM by Deepak Rai

    Change colour by dimensions using parameter control

    Jieliang He

      Basically, I know how to fulfill it if all the color dimension are based on a column. Though, one of the color dimension I would like to make is a calculated field which would be aggregated while being used to color a treemap.

       

      So I have sheet 1, which has a treemap, colored by the field of Achievement (estimated).

      And I have sheet 2, colored by a calculated field, which equals SUM([Achievement (estimated)])/SUM([Sample - Superstore].[Number of Records]).

       

      How can I make a parameter to switch the field for coloring the treemap?