1 Reply Latest reply on Dec 7, 2017 6:49 AM by Simon Runc

    Sorting Bar chart which has 2 metrics aggregated already

    Vivekanandan Venkatesan

      Dear All,

       

      Aim is to sort the simple bar chart in Descending which has 2 metrics [i.e., Capital and City which reflect upon parameter selection].

      For First selection of Parameter shows correct sorting, but when changing the parameter to City the sort remains in Capital sort desc and displays the City Values which is wrong.

       

      Approach 1:  Tried The sort button under menu band to sort descending.

      Approach 2 : To create a Calculated field for Sort and mention the calculated field in Sorting of the dimension.

                              I am getting an error on mixing aggregate and not aggregated values.

                 

      Please use the Tableau workbook attached to review the issue asap.

       

      Kind Regards,

      Vivek