I have attached an excel file. The top resultset is the way the
result gets displayed before the pivot. The second is
after the pivot is applied. I have a wuery currently that gives me
the second resultset after the pivot.
Below is the current query.
Here's what I want to do. I would want to get these values
from a table as there is a table that contains the values in ,[-5],,[-1] that
I have hardcoded in pivot. I have commented out a field in the query as
Select *from tbl1. So here's basically what I am looking at
FOR maintab.scendes in (Select *from tbl1).
Not sure if it is possible or not but your help will be highly