This topic is locked
[SOLVED]

 stacking column

8/12/2018 3:59:09 PM
ASPRunnerPro General questions
R
richard_warwick author

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 8/15/2018

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

R
richard_warwick author 8/15/2018

This is a link to the output: https://1drv.ms/u/s!Aujxvfmwxo33h_RjZehVFKEQ8YbIZw
This is a link to the result: https://1drv.ms/u/s!Aujxvfmwxo33h_RkYFthhWjRTcfzUg
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 8/16/2018

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.

R
richard_warwick author 8/18/2018



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