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

# ignoring dimensions into expression

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

• ###### Re: ignoring dimensions into expression

If you have a chart with dimensions Year, Month and Customer and an expression like sum(Sales), you can use sum(total <Customer> Sales) to sum the sales across the whole range of customers.

• ###### Re: ignoring dimensions into expression

Thanks very much!!

• ###### Re: ignoring dimensions into expression

Hi,

Use TOTAL to ignore the dimensions.

=Sum(TOTAL<Dim1, Dim2, ....> Sales) in this experssion only the Dim1, Dim2... are considered.

=Sum(Sales) / Sum(TOTAL<Dim1, Dim2, ....> Sales)

Regards,

Jagan.