2 Selections wish to have inverse on one only with setanalysis

[#1]

Im sure it's easier than Im making it out but I cant seem to get to my answer.

I have data for financial year , organisation and spend value.

FinYear , Org , Value

I wish user to select financial year and a organisation but the table to display :

Selected Financial year but spend value for all organisations other than the selected.

Thank you in advance.

example/

FinYear	Org	Value
2011/12	A	10
2011/12	A	5
2011/12	B	10
2012/13	A	5

Selection Finyear=2011/12 Org=B

Table to return would be :

FinYear	Org	Value
2011/12	A	10
2011/12	A	5

-- Thank you in advance

[swuehl]

Create a straight table with dimensions FinYear and Org and as expression try something like

=sum({<Org -= {$(=GetFieldSelections(Org))}>} Value)

[#3]

Hello,

This returns a result if just 1 dimension (FinYear) is selected but when Org is selected it is null..

[tresesco]

Try:

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

See the attached sample qvw.

[#5]

Thanks that work I just swapped FinYear for Org for my results ie to keep year selection.

Thank you.

[#6]

hello,

I would now like to have another dimension called project so that my result will exclude any projects that the org has a value against.

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

So Selections:

2013/14 and A

would return

2013/14 , B, WIDGET, 10

I want the data to remain in the selected FinYear , show all data not Org A and projects that A is not part.

Hope that makes sense.

-