Forum Discussion
Create Hierarchy for Pivot
I have a table with 132 response columns. under each column is # of times each response was selected. There is another column that has a measure of stress associated with each response. EX: ask bu...
That is almost what I need! Thank you for replying.
The only difference is where you have the 0-3 under ASK I need the 0-3 still as one of the columns and all of the ASKs under the ASK .
EX:
response 0-3 4-6 7-9
+ ask 2
ask2 3
+buy 3
buy 2 1
+sell 1
sell2 2
sell3 1
sell4 2
Since ASK ASK2 BUY BUY2 SELL etc are now all under the same column, I dont know how to build a hierarchy.
Should I send you my PBIx?
I