4 Replies Latest reply on Aug 17, 2016 3:45 AM by gopi ponnam

    1)which manager in particular region and subcategory has the percent of return sales to the total sales the highest?

    gopi ponnam

      i tried to use fixed LOD expression which has the following equation?

      a) {fixed manager,region,subcategory:sum(sales)}---------------> to find out the total sales for that particular subcategory?

      b) IIF(returned='yes',[sales],null)---------->to find out the return sales of that particular subcategory, region and manager?

       

      finally took the ratio b/a but didn't get answer for that as everything shows 100% returns

       

      any help pls ??

       

      also please find the attached data set with this?

       

      Message was edited by: gopi ponnam please find the attached workbook with this message and thank you for the reply..