# How can I use the total or subtotal in a calculation?

• Author
Posts
• #585

Stratum provides predefined calcs that can help out if you want to use either the total for a measure or the subtotal amount. To use the total there is a specific calc function you can use in the Stratum Viewer Functions. For the subtotal you can back into the subtotal amount from the Stratum provided % of Subtotal function. I’ve included a couple of screen shots to show how you can use both the #Total function and the #PercentOfSubtotal functions to see the totals or subtotals on each row. Of course if you are using these in a calc you’d hide these measures as they have no real value to a user on each row.

Here’s the View – a simple example of getting the total and subtotal in the view: This is the calc for getting the Total into a measure you can use in calcs on each row: Last one – this is the two calc’s needed to get the Subtotal into a measure on each row so you do calcs with it: Any questions or comments post them here. Hope this gives you some ideas on how you can use different levels in calcs in Stratum.

You must be logged in to reply to this topic.