Waterfall chart doesn't work well with LineItem Subset
I'm having some trouble with creating a waterfall chart to analyze the all the factors of ups and downs between actual and forecast. First of all, I created a module (A) with all the factors as lineItems including star, subtotal, and end summary, and then, because I have to do some filtering and other sum-up mapping basing on other logic like refering to flag, I created another module (B) that applied a lineitem subset and collect the data from which I created (A) before. And then I have to publish the waterfall chart from Module B, but I couldn't get what I wanted, due to that the waterfall igores the start, subtotal and end I already included in the lineItem Subset.
Module A (simple version):
* The waterfall looks like what we want, but we have to do let users customize the mapping and filter the items dynamically so we have to change the lineitem into lineitem subset.
Module B (simple version):
This doesn't look right....It takes the subtotal and end summary as factor items while adding another end total by itself.... I can exclude the end summary from the lineitem subset, but I have to keep the Subtotal ones.
Does the waterfall only work with lineitem or list but can't work with lineitem subset? I regard the lineitem subset as the same thing as list though.
In order to be notified as this idea progresses, please go to the link below and click the “thumbs up” icon to kudos the idea. This not only helps you track its status, but also helps increase the priority for our Product team to consider.