ignoring dimensions into expression

[Anonymous]

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

[Anonymous · Accepted solution]

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.

[jagan]

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.

[Anonymous]

Thanks very much!!