Jump to content

Remove Filtered Out data from Calculated Columns

Manoj Chaurasia

Recommended Posts



I have a few calculated columns in my analysis. I would like the results of the calculation to change accordingly when data is filtered.


For instance, if my calculation is: Count([PubType])

I would like the result to be different when i filter out some of the PubTypes. Right now, this does not happen. The calculation takes into account ALL the data that is in the data table regardless of whether it is filtered out or not.


Does anybody know how to get around this


Thanks a lot!

Link to comment
Share on other sites

  • 2 years later...
Calculated columns are not dynamically recalculated, so you would need to create them as 'custom expressions' which are dynamic. You can create the custom expression on any axis by right clicking on the Axis selector and selecting 'Custom Expression...'. The resulting interface looks nearly identical to the calculated column interface, but the expression will be recalculated each time you filter.
Link to comment
Share on other sites

  • 4 years later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...