Trellis Chart Grouped Expressions

[#1]

Good Day All,

In the attached QVW example I have Purchase Receipt transactions whose cost I want to show by Item and MonthYear in a trellis chart. Additionally, I want to show the percentage change from the prior cost. The expressions are Grouped. To observe the results I made the chart a fast change between a pivot table and a bar chart.

The costs and percentage change renders correctly in the pivot table, but the percentage does not in the trellis chart.

Any thoughts on this behavior?

Thanks in advance,

Rich D

[#2]

Anyone encounter this?

[#3 · Accepted solution]

because Before function can only be used with Pivot tables, it returns null for all other chart types...so, you are not getting values for Trellis Chart....I hope it is helpful and I believe you know other ways to achieve the same output....

[#4]

Thank you Ashutosh,

I guess it's back to the drawing board for this one.

Rich