Get Free Trial

find the difference between two columns in grid that are breakdowns

Answered
Michael T 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   
 

1 answer

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster 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

Please login or Register to Submit Answer