[rwarwick]

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.

[admin]

Can you post a screenshot that would explain what you are after?

[rwarwick]

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

[admin]

The only way to implement a stacked column is to have multiple data series meaning that you need a separate data column for each series.

[rwarwick]

admin, on 16 August 2018 - 09:14 PM, said:

The only way to implement a stacked column is to have multiple data series meaning that you need a separate data column for each series.

That's too bad but at least I know now.
Thank you for your help.

Rick