Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Create a straight table with dimensions FinYear and Org and as expression try something like
=sum({<Org -= {$(=GetFieldSelections(Org))}>} Value)
Hello,
This returns a result if just 1 dimension (FinYear) is selected but when Org is selected it is null..
Try:
=Sum({<FinYear=e(FinYear)>}Value)
See the attached sample qvw.
Thanks that work I just swapped FinYear for Org for my results ie to keep year selection.
Thank you.
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.
-