Set Analysis : Multiple Selections to consider

Thu, 06 Nov 2014 15:54:14 GMT

Hello,

I have a data set as per the table below and Id like to use set analysis to :~

FinYear	Org	Project	Value
2013/14	A	WIDGET	10
2013/14	A	WIBBLE	5
2013/14	B	WIDGET	10
2014/15	A	WILKS	5
2013/14	B	WAKKA	10

Selections made :

finYear= 2013/14

Org = A

would return

2013/14 , B, WIDGET, 10

2013/14 ,B WAKKA , 10

I want the data to remain in the selected FinYear , but show all projects thats Org A did not have a value for ie projects that A is not part.

I have created :

=Sum({<org=e(org)>}Value)

this gives all values that A was not part but still includes projects that A had values allocated against ...

Hope that makes sense.

Re: Set Analysis : Multiple Selections to consider

MK_QSL — Thu, 06 Nov 2014 17:03:14 GMT

Can you post the expected result as per your description? It's difficult to understand the logic.

maxgro — Thu, 06 Nov 2014 19:04:12 GMT

maybe

sum({1<Project=-P(Project),FinYear=P(FinYear)>} Value)