4 Replies Latest reply on Feb 1, 2016 7:56 AM by Christopher Demundo

    Sorting Blended Data - Multiple Axis Crosstab

    Christopher Demundo

      I have a calculated field:

       

      Percent to Budget = SUM([Sales])/SUM([Budget]).  Sales and budget are located in two data sources. 

       

      I'm using a multiple axis crosstab as I need to be able to color individual columns separately, but I can't sort the data on "percent to budget", it doesn't show up in the "Sort by Field" list. 

       

      Any ideas on how I can sort by this field?