4 Replies Latest reply on Jul 29, 2018 9:58 AM by Tony Smith

    How to auto populate measure (Group Measure)

    Tony Smith

      Hi All,

       

      Can someone please advise me on how to group a measure in tableau?

       

      What I am trying to achieve is to group the measure in the attached report, so when a user selects A1 in the filter the measures will auto populate chart 1 and chart 2 with the measure values.

       

      See below on how I want to group them when they are selected

       

      A1 to auto populate chart 1 and chart 2 with

      Budget Sales

      Current year sales

      Last year sale

       

      B1 to auto populate chart 1 and chart 2 with

      Current year order

      Last year order

       

      C1 to auto populate chart 1 and chart 2 with

      Current year RCP

      Last year RCP

       

      D1 to auto populate chart 3 and chart 4 with

      Var for RCP

      Var for Order

      Var for sale

       

      B1 to auto populate chart 3 and chart 4 with

      YoY – Actual

      YoY – Budget

       

      Thanks

       

      Regards

      Tony