Jump to content
Changes to the Jaspersoft community edition download ×

Analysis view - filtering options


Recommended Posts

I'm evaluating JasperServer Professional 2.1, and we have a question about filtering with the Analysis/JPivot view.


For 'Foodmart Sample Analysis View', as it opens by default, how would you then adjust the configuration so that it included data from all stores except Beverly Hills?


I don't see how to use Filter to do this, because there is no option to select all-except-one as they are radio buttons.


If I put Store into the Rows section, I can click down and select 'All' and then uncheck 'Beverly Hills', but that doesn't appear to change the numbers at all - it just hides that store from display, still counting them in the totals at the top line.


Thanks for any help,



Link to comment
Share on other sites

  • 2 weeks later...
  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

If you exclude a store from the display, its effect will not be removed from a higher level total, like 'All Stores'. What you want is a different rollup, like 'All Stores - Beverly Hills'.


There is no way to do this through the UI. You will need to create MDX with a calculated member or named set that does the right thing.





Link to comment
Share on other sites

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...