filters in webi
I have a webi report on e-fashion.Created the report with city,state,year,salesrevenue.Then i applied the report filter on year.Picked the value 2001 for year (among 2001,2002,2003 values) from Inlist option. So i get the 2001 report data. But i also need to display the values 2003 and 2002 in the report in a cell or as a column. The basic thing is that i need to display those values(not the entire report data of 2003 and 2002) which i didn't pick while applying the report filter.
Please do help....
Thanks in Advance..
If you would have been performaing calculations then you could have used NoFilter function but there is no such function available in Webi to accomplish your requirement.
Though I have an affective workaround.
Create a new query on the same Universe.
Select the Year object. Do not apply any filter.
Run the query and select the option to "Insert the table in the current report"
It will insert a new table in the report with all the values.
Make sure the Year object from Query1 and Query2 are not merged.
From the Document Properties uncheck the option "Auto Merge Dimensions"
I hope this helps.