Jump to content
Changes to the Jaspersoft community edition download ×

Analysis view - filtering options


nicholas

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,

 

Nick

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.

 

 

Sherman

JasperSoft

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