3 Replies Latest reply: Dec 2, 2012 5:18 AM by steve peroni RSS

    ignoring dimensions into expression

    steve peroni

      Dear all,

      is it possible to ignore the dimension into a calculated expression ?

      What I'm trying is this:


      Year Month   Customer     Sales          %

      2012  10          AAA          1500          12              




      The % is calculated as   sales/total sales for year and month, ignoring the customer dimension

      Sales represents the total sales per customer, on October 2012. Year and Month are selected values by list boxes. The dimension is CUSTOMER


      Any help is reallu appreciated


      Thanks in advance for your help