Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
It is possible to use PivotTable estutura tree? ie, in a column to show the hierarchy between the dimensions?
example attached
Tanks,
Renato
Renato,
I think something similar like shown in your excel file should be possible.
You will have to define the hierarchy somehow in your script, I used a simple table to define the dependencies.
Then you could use a pivot table with two dimensions, first the main category (like Moda Masculina), second the subcategories (like the different camisas).
Then you could add partial sums to the dimensions as you like or e.g. enable indent mode on tab style (like in the first chart of my example).
Hope this helps,
Stefan
Renato,
I think something similar like shown in your excel file should be possible.
You will have to define the hierarchy somehow in your script, I used a simple table to define the dependencies.
Then you could use a pivot table with two dimensions, first the main category (like Moda Masculina), second the subcategories (like the different camisas).
Then you could add partial sums to the dimensions as you like or e.g. enable indent mode on tab style (like in the first chart of my example).
Hope this helps,
Stefan
Tanks!
Swuehl