6 Replies Latest reply: Mar 4, 2016 5:04 AM by Paola Alcázar Lorenzo

# Obviating a dimension in an expression of a pivot table

Hi all,
Do you know if you can tell an expression that group by one of the dimensions in a pivot table ?

My dimensions are , Agency , Campaign and Product and do not want to take into account in the expression the Product dimension , but the others.
I tried to put sum ( { < product = >} ContactosUtiles ) to join me useful contacts regardless of the product dimension does not work.

Thank you

• ###### Re: Obviating a dimension in an expression of a pivot table

Not sure, but may be this:

Sum(TOTAL <Agency, Campaign> ContactosUtiles)

• ###### Re: Obviating a dimension in an expression of a pivot table

I have also proven , but does not work .

Thank you

• ###### Re: Obviating a dimension in an expression of a pivot table

Would you be able to share a sample?

• ###### Re: Obviating a dimension in an expression of a pivot table

Hello Sunny T,

I give you an example:

Agency Campaign Product    ContactosUtiles

P111

C11        P112

P113

----------------------------------------------------------------------------------

P121

A1            C12        P122

----------------------------------------------------------------------------------

C13        P131

----------------------------------------------------------------------------------

I need to calculate the useful data regardless of the product dimension

I tried it with:

- Sum(TOTAL <Agency, Campaign> ContactosUtiles)

- sum ( { < product = >} ContactosUtiles )

but it does not work

Thank you

• ###### Re: Obviating a dimension in an expression of a pivot table

Hi,

Try like this

sum (TOTAL <product> ContactosUtiles )

Regards,

Jagan.

• ###### Re: Obviating a dimension in an expression of a pivot table

Hi jagan,

That would work if it were defined by ContactosÚtiles products.

ContactosÚtiles is not defined by products so I want to ignore this dimension.

Thank you.