9 Replies Latest reply: Apr 18, 2014 9:58 AM by Vinay kumar Bangari RSS

    help with sorting in Pivot table

    Vinay kumar Bangari

      Hi i have  pivot table in which i have Item Type Desc, sport & Style and Name...with expressions shown below in the qvw document. All i want is sort on Style Dimension with the following expression if total Bgt margin % is less than 2014 ACT margin % then arrange those Styles in ascending order and if total Bgt margin % is greater than 2014 ACT margin % then arrange those Styles in ascending order. Please see the qvw document and as well as attached is the screen shot how it should look like....