2 Replies Latest reply on Jul 30, 2018 2:31 AM by Naveen B

    Sorting option unavailable when using table calculations with normal measures

    Kapil Lehar

      Hi,

       

      I'm using sample super store dataset to explain the issue that I'm facing with my real dataset.

       

      I have customer name in the rows shelf.

      Profit,sales and a table calculation in the measure value shelf.

      Table calculation is : sum(profit)/sum(Sales) and then i apply a percent of total table calculation

       

      I have noticed that when i keep this table calculation at the third place the sorting options beside the profit and sales column are available but when i move this table calc to the first place the all sorting options disappear.

      Why does this happen ?