Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Comparable values in MDX Expand / Collapse
Posted Monday, July 1, 2013 5:13 AM


Group: General Forum Members
Last Login: Friday, October 24, 2014 8:01 AM
Points: 19, Visits: 47
Hi all

I really need ur help...

Imagine this dataset:

Year Institution Value

2012 A 130

2012 B 150

2013 A 200

When I fetch the data into a chart I don't want to see the institutions that don't have values for all years, so I can compare with some logic... I don't want to have a chart showing me the values of A for 2013 if I don't have values for 2012. Do I make myself clear?

If anyone knows how can I solve this problem, please help me :)

Thanks in advance.

Best regards,

Post #1469001
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse