4 Replies Latest reply: May 9, 2013 9:16 AM by Bradley Coyne RSS

    Set analysis candidate?

    Bradley Coyne

      Hi.

       

      I have the following issue.

       

      i have the following tables in my analysis.

      i can view either by Item or Year;

       

      Item

       

       

      Item
      Qty
      Gross Margin
      ListPrice
      BasePrice
      Comparison
      00111616 14(ListPrice  - BasePrice)/BasePrice
      002436910-10%

       

       

      However when i wish to look at the Comparison over the year i would like to be able to view all Items that were sold in that year and divide them by their BasePrices to get a % Comparison. Now i recieve -Null, because the no item is selected.

       

      Year

       

      Year
      Qty
      Gross Margin
      ListPrice
      BasePrice
      Comparison
      20135050010= All Base Prices Added together(50-Baseprice)/Baseprice
      20121004004= All Base Prices Added together4-Baseprice

       

       

      What i need to do here is make my tag a baseprice even when no item is selected for the Year dimension.

       

      Any help is appreciated