Obviating a dimension in an expression of a pivot table

[#1]

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

[sunny_talwar]

Not sure, but may be this:

Sum(TOTAL <Agency, Campaign> ContactosUtiles)

[#3]

I have also proven , but does not work .

Thank you

[sunny_talwar]

Would you be able to share a sample?

[#5]

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

[jagan]

Hi,

Try like this

sum (TOTAL <product> ContactosUtiles )

Regards,

Jagan.

[#7]

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.