I'm having some troubles with my Sankey chart, that I'm using to show the Actual vs Budget sales.
If you see field A, in pict1 the total value is -7.9, but in dimension B, the sum won't add up. I exported the data, and found that negative comes from a combination of B4, C3. As you can see, B4 isn't displayed, not even when I just filter by C3 (pict2 ). If I manually filter B4 with the filter panes, the chart appears empty (image not attached).
How can I work around this? I don't see why I can have negative values in Dimension C, but not on dimension B.
