Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I built a stacked bar chart, that has different colors for multiple currencies. Values displayed on the data points. Y-value sorted descending. However, in the graph it looks like this (-524 is just a value for one currency in that bar, total value there is 209,000,000).
and yes I know that adding up different currencies is not great representation, but it has to be done, and sorted.
is there a way to display the actual 209,000,000 or to display sums of each currency?
Can you attach some sample data?
the fields I use is customers, amount, and currency
These are actually all the values that are summed in the bar showing -524, any ideas why does it only show the sum of two negative numbers.
113219 |
8000 |
50000 |
4580 |
-500 |
209000000 |
2800000 |
24000 |
1009050 |
1000 |
-24 |
2344497.71 |
2000 |
1500 |
Attach sample qvw.
I also found this question someone asked, but no valid answer there as well