Columns with diffrent measures

Hello Jarek,
Thank you for writing to us.
We have checked your screenshot, and it helped us to get a general idea of your case.
 
Yes, it is possible to get a similar report in Flexmonster.
Also, we noticed additional data representation feature, which shows some percentage of data near the main value. If we understood it correctly, for "All" column, it is some sort of percent difference, and for other columns, it is a percent of row total.
When using Flexmonster, you can achieve such sort of visualisation with the help of additional customization options such as customizeCell hook.
 
Still, the nature of some columns is not clear to us. Could you please share with us some additional information such as formulas for calculating columns and your data structure? That would help us to provide more specific steps of how to implement such a report.
You are welcome to write to our e-mail if you need to share some sensitive data.
 
Waiting to hear from you.
Regards,
Dmytro

Hello, Jarek,
 
Thank you for providing further details regarding your use case. 
 
The detailed descriptions and the sample data set helped us to understand the situation better.
Our team is currently working on your case.
We will make sure to reach out to you shortly.
 
Kind regards,
Vera

Hello, Jarek,
 
Thank you for giving us some time. 
 
Using the descriptions and the provided data, we were able to achieve all the calculations. 
We have prepared a code sample for reference (please see "pivot.html" in the attachments). 
 
Below are the steps on how the resulting visualization was achieved: 

1. Data preprocessing:

   We would like to kindly explain that to achieve the described calculations, the data structure needs to be adjusted. 

   Please consider preprocessing the data from: 

   {
     "order_id":3651,
     "order_date":"2020-08-01",
     "order_status":"CANCEL",
     "in_process":0,
     "confirmed":0,
     "by_phone":0,
     "cals_count":3,
     "order_price":137.00
   }

   to the following format: 

   {
     "order_id": 3651,
     "order_date": "2020-08-01",
     "order_status": "CANCEL",
     "in_process": 0,
     "confirmed": 0,
     "by_phone": 0,
     "cals_count": 3,
     "order_price": 137,
     "CANCEL": 1,
     "TRASH": 0,
     "NOT NEEDED": 0,
     "FAIL": 0,
     "PACKED": 0,
     "COMPLAINT": 0,
     "CARRIER_RETURN": 0,
     "CONTRACT_OUT": 0,
     "FINISHED": 0,
     "AFTER_RETURN": 0,
     "DELIVERED": 0,
     "RETURN": 0,
     "SEND": 0,
     "TO_SEND": 0,
     "NO_ANSWER": 0,
     "RECALL": 0,
     "PROCESSING": 0
   }

   This will make it possible to create calculations based on the order status value.
   In the provided example, the data is preprocessed during runtime.

2. Creating the base calculations:

   The base calculations were created using calculated values.
   Please see our calculated values guide for more details: https://www.flexmonster.com/doc/calculated-values/.

3. Adding additional (second) calculations to the grid cells:

   For adding the second values, the getData() and customizeCell() API calls were used.
   The getData() API call was used to get the needed additional calculations. 
   We used the "%differenceofcolumn" (for "All Leads" and "Finances EPL-a" columns) and the "percentofcolumn" (for the rest) aggregations for the second values.
   The customizeCell() API call was used for adding the received calculations to the grid values.

 
 
Please let us know if this works for you. 
Also, could you please let us know your company name and if you are our client (this can be shared via email)? We need this information for our records. 
 
Looking forward to your reply.
 
Kind regards, 
Vera

Hello, Jarek,
 
Thank you for your kind feedback.

We are truly happy to hear that the provided solution was helpful.
Please feel free to reach out in case of any further questions.

Kind regards,
Vera

Hello, Nithin,
 
Please find the answer in the following thread: https://www.flexmonster.com/question/we-can-display-multiple-value-in-single-cell/
 
Kind regards,
Nadia