3 Replies Latest reply: Jul 6, 2016 11:11 AM by Vineeth Pujari RSS

    Pivot table sorting with 2 calculated dimensions

    Pawel Kietlinski

      Hi, I need to create table with two dimensions. First one with top 5 value based one first expression (expanded) + others row sowing sum of rest (collapsed) + Grand Total. 2nd dimension will show top 3 values based on 1st expression + total row. I manage to create top 5 and top 3 values but i have a problem with proper sorting. I've tried adding "hidden' expression with some calculation based on RANK and AGGR function but without success. Table should look like this:

      06-07-2016 13-37-37.png

      Is this possible? if so then how?