Subtotal

[#1]

Hello,

I have a table with sales by month and I want to show the subtotal about it. The issue is, I want to show the subtotal, only if more than 1 month be selected, do you guys know if it is possible?

Sincerely, Luiz Bisco

[hector_munoz · Accepted solution]

Hi Luiz,

Short time ago we had the same problem and we had to solve it using 2 distinct objtecs: one with subtotals and other without them. They show or hide based on the number of selected values in a field.

Hope you find another way.

Regards,

H

[#3]

Thank you, it works!

[sunny_talwar]

May be something like this in one object

If(GetSelectedCount(Month) > 1, Sum(Sales), Aggr(Sum(Sales), Month))

The above will only show a total when more than one Month is selected in the Month field