5 Replies Latest reply: Nov 6, 2014 8:38 AM by Chris Whitlock

# 2 Selections wish to have inverse on one only with setanalysis

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.

example/

FinYearOrgValue
2011/12A10
2011/12A5
2011/12B10
2012/13A5

Selection Finyear=2011/12 Org=B

Table to return would be :

FinYearOrgValue
2011/12A10
2011/12A5

• ###### Re: 2 Selections wish to have inverse on one only with setanalysis

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

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

• ###### Re: 2 Selections wish to have inverse on one only with setanalysis

Hello,

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

• ###### Re: Re: 2 Selections wish to have inverse on one only with setanalysis

Try:

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

See the attached sample qvw.

• ###### Re: 2 Selections wish to have inverse on one only with setanalysis

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

Thank you.

• ###### Re: Re: Re: 2 Selections wish to have inverse on one only with setanalysis

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.

FinYearOrgProjectValue
2013/14AWIDGET10
2013/14AWIBBLE5
2013/14BWIDGET10
2014/15AWILKS5

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.

-