"Classic Pivot table" design
I want to create a table that is similar in style to the classic pivot table in excel. In that sense I also wish to add multiple attributes from the same "dimension" from my data source/cube. In short, I want to create a table of orders with a selected number of rows (attributes). In this example I want to include only what we have defined as "large orders". In my data source, I have a dimension named "Larger Order". I then want my table to include both "Order Type", "Delivery Month" and "Large Order No", as seen below.
However, when I have added "Large order" to the row's section to my table in Discovery, I cannot get any more rows in of the same dimension. Is there anyway I can work around this?
Many thanks in advance!
Hi Niclas Lovgren ,
Do you want something like this? In this case we have a product hierarchy that drills down from product categroy to product. I did not put Product (the lowest member of the hierarchy) into the Rows, but what you need to do here is drag and drop the Hierarchy, in your case "Large Number" into the drop zones. Then you are able via the plusses in the grid to drill down and see all the data.
I hope that helps!
If you have any further questions, do not hesitate to ask them.
Thank you both for your replies and sorry for my late reply.
I am more looking for a way to structure the table differently, similar to a "classic pivot table". In the example below. First part is the way Pyramid allows me to show the data but I am looking for a way to structure it as the second table shows and where the item labels are shown on each row.
The error also persists. Pyramid does not allow me to drag each member of the hierarchy to the rows section. I want each column to show "Order type", "Delivery Month" and "Large Order No". When I start with "Order Type" and drop it to the Rows section. In the rows section it then only says "Large Order" and having that in the rows section, Pyramid does not allow me to drag and drop any more of the other three members in the hierarchy. Nothing happens when I try.
In the end I want a table looking something like below
Do you have any idea of how I can make this happen?