3 Replies Latest reply on Apr 17, 2018 4:08 AM by chowdary v

    How to Top N in cross tab without unnecessary empty data row



      Would like to seek your advise on how to implement the following.


      Objective: to display the product in price segment (let say 500 bin) by sub category and comparing category side by side


      1) average price must be in sorted in descending within segment. OK

      2) top n sales must be able to filter top n sales within segment. OK.

      3) not to show sub-category if it is empty. (for 500 price segment, Rows like Appliance should not be in the list)


      I have achieve the 1 and 2 using some sorting and index() function. But rows that has no values are also showing.


      How can I achieve the item 3?


      Thanks in advance. Rgds