Pivot Table Expression column

[sohb2015]

Hello All,

As we know, in a pivot table expression always come after the dimensions. Now i have requirement where I need to show the expression before few of the dimension.

For Ex.

Year       Country      Sale     Status     

  2015     Australia    1000      A

  2015     India           2000      A

Sale column is a expression: sum(sales).

Is it possible to design the pivot table like this?

Please help

Thanks

[effinty2112]

Hi Sohini,

A straight table would be a better choice for you. You can drag the expression column along to the left but you can't have a horizontal dimension like you can in a pivot table.

Cheers

[rubenmarin1]

Hi, one option is load dimensions after the expression as an expression instead of dimension.

Other option is the reverse: load the expression as a calculated dimension:

=Aggr(Sum(Sale), Year, Country)

Not tested.