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 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 https://www.flexmonster.com/doc/calculated-values/
Unfortunately, it seems that our library cannot suggest the way to do this.