ColumnNo() as horizontal Dimension

[jordicastilloga]

Hi,

I'm trying to build a pivot table with two dimensions:

- Dimension 1: vertical with a ValueList. 

- Dimension2: horizontal with the Customer Code. But, instead of the Customer Code, I want the column number as a header.   So the dimension I think I should use is something like this: dual(ColumnNo(),Customer_Code).

Unfortunately, its not working.

Does anyone know how to do it?

Thanks!!!

Jordi. 

[sunny_talwar · Accepted solution]

How about this?

Aggr(Dual(RowNo(), Customer_Code), Customer_Code)

[jordicastilloga]

Thank you very much!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! It works!!!!!