How can I have a dynamic subtotal based on threshold?

[posywang]

Hi,

I was trying to create a pivot table that only shows data over threshold. I was able to create an expression that show and hide based on the input threshold. However, the subtotal doesn't change at all and always shows the original subtotal. I attached a sample file for your reference. Please advise. Thank you!

[MayilVahanan · Accepted solution]

Hi @posywang 

Try like below

sum({<OrderDate={"=Sum(UnitTotal)>=$(v1)"}>}UnitTotal)

[posywang]

It works! Thank you so much for your help!!