[SOLVED] stacking column stacking column with one data series
Posted 12 August 2018 - 07:59 PM
I have a single series of data that return three rows of data:
1 101001 100876.00
2 101003 83769.03
2 101006 2098.86
I would like to stack the wip data as a bar column.
All I can do is get three columns, one of each.
Posted 16 August 2018 - 02:41 AM
This is a link to the result: https://1drv.ms/u/s!...kYFthhWjRTcfzUg
I am looking to have one column by stacking each of the three results on top of each other.
It works if there is one row of data with three fields but not three rows of data with one field in each.
I am using a CASE statement to retrieve the data so I am typing SQL directly rather than Query Designer.
Thanks for any suggestions.
Posted 18 August 2018 - 03:17 PM