Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This is how my dataset looks like:
ItemType ItemCategory ItemName
ItemType1 ItemCat1 Item1
ItemType1 ItemCat1 Item2
ItemType1 ItemCat2 Item3
ItemType2 ItemCat1 Item4
ItemType2 ItemCat2 Item5
ItemType2 ItemCat2 Item6
ItemType3 ItemCat1 Item7
ItemType3 ItemCat2 Item8
ItemType3 ItemCat1 Item9
I am trying to display this in PivotTable so that i can get tree view kind of structure with ItemCategory as Row rather than column.
ItemType ItemCat1 ItemCat2
-ItemType1 Item1 Item3
Item2
-ItemType2 Item4 Item5
Item6
-ItemType3 Item7 Item9
Item8
To achieve this, this is what i did.
I created ItemType and ItemCategory as Dimensions and ItemName as Expression. But it does not show me the data in the ItemName column.
I created ItemType, ItemCategory and ItemName as Dimensions, but it does not let me drag and drop ItemCategory column on top of ItemName. It however shows the data.
I created ItemType, ItemCategory and ItemName as Dimensions and ItemName as Expression, it allows me to drag and drop the ItemCategory on top of ItemName expression column but the result is not what i am looking for.
What am i missing here?
ItemCategory has been pivoted out as a Column... it is not a row if you look closely .. you can remove or minimize the "label" column if you like ...
Well, Instead of using PivotTable, can we use Straight Table and achieve the same result without doing too much data manipulation?
After fiddling around a little bit I discovered that it was possible to get your desired layout both with Straight Table and with Pivot Table. I had to introduce an extra field when loading the data to number the values for each ItemCategory. Then this number could be used to fill the Chart more efficiently.
The result looks like this and I have attached a new QVW demonstrating how it is done. I dont have more time just now to explain some of the details but feel free to ask if anything is unclear and I will answer most likely tomorrow.
And I made a version with some more random test data ... just to see that it works as it should...
Thank you. Appreciate your help.
Bravo!