Set Analysis : Multiple Selections to consider

[#1]

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.

[MK_QSL]

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

[maxgro]

maybe

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