If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Filter Chart on List with Calculated Member

Started by reneincer, 19 Nov 2013 12:25:59 PM

Previous topic - Next topic

reneincer

Hi there,
I have a calculated member, and a set with many items including the calculated member,

I have a list with this set, and a chart for each Item, with Master Relation Ship, because Chart does not allow to filter, so I link the set from List to Chart,  the list filters all items except the calculated member,

Do you know if i'am doing something wrong or chart does not allow to filter with calculated member on Master Detail Relationship?

CognAsh

Hi,

I'm not sure if I understand correctly. Are you trying to FILTER a chart? If this is the case then you cannot do this as charts are rendered at build time and there is not client side charting engine.

What you need to do is create a deck with a card for each of your filters then master-detail the chart to the card. Create a control that selects the necessary card.

For example. If you have products ABCDE and you want to show a chart per product, then create a deck with cards A,B,C,D,E and put a chart on each card. Master-detail the chart to the card (to filter the chart to the relevant product) then create a button bar with buttons A,B,C,D,E. Click button A will show card A which will have a chart filtered on product A.

Hope this helps.

Ash