Get Free Trial

Using Sub Totals in a calculated Measure

Ravi asked 4 days ago

Is it possible to use the sub total of a column in the formula for a calculated measure? I see a way to get a grand total in a calculated measure thru the formula(
 Is there any such formula to use subtotal? 

4 answers

Illia Yatsyshyn Illia Yatsyshyn Flexmonster 4 days ago

Thank you for posting on our forum.
Please note that the mentioned forum thread describes particular aggregations (% of column, % of row) available in Flexmonster. Grand totals are used for a better explanation of how these aggregations operate.
In fact, it is not possible to refer to grand totals or subtotals directly in the formula.
Please let us know if any other questions arise.
Kind regards,

Ravi 2 days ago

Thanks, Illia Yatsyshyn!
Can we expect “referencing sub-total and grand-total” in Flexmonster in the future versions? 

Illia Yatsyshyn Illia Yatsyshyn Flexmonster 1 day ago

We have sent the response to your question via email.
Feel free to reach out if additional questions arise.
Kind regards,

Kevin Nguyen 1 day ago

I also have users who would like to use the Grand Totals and Subtotals in their calculated measure’s formula.
The current workaround we are using is to use the sum and percent of column aggregations to calculated the grand total in their calculated measures.
(sum(“Measure”) / percentofcolumn(“Measure”)) * 100 = Grand Total of Measure
This is obviously not ideal, but it can work in a pinch.


Please login or Register to Submit Answer