put many dimensions as pivot

[pgalvezt]

Hi,

I am going to try to explain this problem.

I have a dimension (Departamento). This Dimension brings many items:

-Ingresos de la explotacion

-Costo de ventas

-Otros ingresos de la explotacion

etc

I would like to do many calculations with this items and try to clone an excel file: as a QlikView Pivot.

For Example:

Excel File:

Ventas:  6347

Costo de Ventas: -4331

Margen de Explotacion: 2027

I would like to create the same excel file in QlikView.

I don´t want to see "otros ingresos de la explotacion" Just Ventas, Costo de Ventas, and Margen.

Besides I want to add another row with  % (Margen de Contribucion/Ventas)

and another row add the GAV.

Thanks!

[pgalvezt]

Hello!

Any Help?

Thanks!