🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Non-Additive Measure

Answered
Jason Lewis asked on June 1, 2021

Is there a way to add a non-additive measure? Setting aggregation to none does not seem to work.

3 answers

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster June 2, 2021

Hello, Jason,
 
Thank you for reaching out to us.
 
We suggest considering one of the following approaches:

  1. Hiding the value completely by setting its visible property of the Mapping Object to false.
  2. Specifying its type as id in the mentioned mapping object.

 
If these options are not suitable for you, please provide us with additional information about how this field is gonna be used in your case.
 
Looking forward to hearing from you.
 
Regards,
Illia

Public
Jason Lewis June 7, 2021

Those options do not appear to be working, maybe you can provide an example?
In my case I have a value for the number of days under review which should be the same for all values, no matter if it is drilled down or rolled up in a summary. This value is used in another calculation. For example I am looking at 180 days of data and the 180 should be the same value for every data element I am looking at.
 

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster June 9, 2021

Hello, Jason,
 
Thank you for the clarification.
 
If we understand correctly, your requirement is to have some constant value that would not be aggregated and serve to compose calculated values.
 
In case our assumption is correct, we suggest using max or min aggregation in order to represent this value as a constant. We have prepared the following JSFiddle for your reference: https://jsfiddle.net/flexmonster/28aqcufj/. It demonstrates how to use the “Tax” field as a constant instead of aggregating it along with other values. The “Tax” field is used to compose a calculated value “Total price with taxes”.
 
Please let us know if it works for you.
If we did not get the idea correctly, please provide us with a detailed illustration of the desired functionality.
 
Looking forward to hearing from you.
 
Kind regards,
Illia

Please login or Register to Submit Answer