I figure there has to be a simple answer to this.
I have a single series of data that return three rows of data:
account wip
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.
Page 1 of 1
[SOLVED] stacking column stacking column with one data series
#3
Posted 16 August 2018 - 02:41 AM
This is a link to the output: https://1drv.ms/u/s!...jZehVFKEQ8YbIZw
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.
Rick
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.
Rick
Page 1 of 1