Get Free Trial

Calculate field value based on dimension level

Alessio asked on August 9, 2018

I wonder if is possible to write a non-linear expression in formula for calculated field based on the hierarchy level with JSON datasource. For example, if I have Category and Product on rows I want to calculate Price like A+B on Category level and like C*F/2 on Product level. 
I know I can manage this behaviour in MDX with scopes but I have a flat JSON datasource.
Is there a way to do something like that with your library? 
Thank you,

1 answer

Iryna Kulchytska Iryna Kulchytska Flexmonster August 9, 2018

Hi Alessio,
Thank you for posting your question.
The component does not support the described calculated fields where the formula depends on the hierarchy level for flat JSON datasource.
Here is the article that describes what calculated fields are supported for JSON, CSV and OCSV data sources
Unfortunately, it seems that our library cannot suggest the way to do this.
Kind regards,

Please login or Register to Submit Answer