col1 col2 col3 col4
4 x y z
6 z x y
8 l l m
i wanted to create bar chart and wanted to use one column using filter on x,y,z,l values from 3 columns can i able to do that
I think you will need to transform your crosstable into a "normal" table. See here what is meant: The Crosstable Load.
thats true but i have 100 coulmns and wants to change only above 3 columns from it and not alll
You could just transform these 3 columns within an extra table and keeping the other like they is but I think it's a rather uncommon approach. I believe I would transform the whole table ...
yes.that is only option i can see now..seprate table
Retrieving data ...