asked on September 2, 2021
If we have sales growth figures for different quarters, e.g. Q1, Q2, Q3, Q4
and we just want to show the most recent two quarters, and the growth on a grid,
are we able to get the difference between the two columns?
e.g.
Measure: Sales
Submeasure: quarter
Q3. | Q4. |. Growth
30 | 40 | 10
⋅ September 3, 2021
Hello,
Thank you for posting on our forum.
We suggest checking out differenceofcolumn and differenceofrow aggregations available in Flexmonster. They serve to find differences (growth in your case) between different members (Q3, Q4) of the same field (quarter).
Here is the JSFiddle we prepared for the demonstration: https://jsfiddle.net/flexmonster/y68h17rv/.
Please let us know if it works for you.
Kind regards,
Illia
