Calculated Fields

Posted by: bradwery on 3 August 2017, 4:04 pm EST

  • Posted 3 August 2017, 4:04 pm EST

    It's not terribly clear from the documentation. I'm evaluating ActiveAnalysis for a webforms application. How do I add calculated fields to the pivot table? In some video's I saw, you right click on the measure and then selected various options for calculated values. These options don't appear in the web component version.

  • Replied 3 August 2017, 4:04 pm EST


    You can right click on any measure, click on Add Measure and then, set the Aggregate function as "Composite" along with the expression as required. For example, you may add two fields like this :

    =Fields!Population.Value + Fields!LandArea.Value

    Note: The end users need to write the name of measures as defined in the schema.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels