Create one more criteria(combine similar request) and calculate OD value from it. Other two from the first criteria. Add result column from the criteria pane. Set aggregation rule as server complex aggregate. Done.. Kindly let me know if any further info required.
Thank you for the reply Aj.
However I am not able to grasp what you mentioned.
Both criteria have dashboard prompts which does the search on User Global ID and Time range.
Could you please explain what you meant by "Create one more criteria(combine similar request) and calculate OD value from it."
i will give you an example. Hope you will mark for my time ........
Hope you are aware of how to combine similar request.
in the first criteria you have
Year Goldprice Loanamount 0
Year 0 0 Overdraftamount
both the criteria keep the filters required.
Add a result column (option you can see in the subject area pane) in that add all three columns. You can choose it from the columns. formula will come somthing like below
I think Aj mentions about union reports. And adding a result column for that.
I don't think I would be able to union reports to get the required answer.
The thing is, the first analysis will have just one column with its own filters.
I create the other analysis with the gold and loan columns and its own filters and save it.
Now to union the reports i have to have the same number of columns in both analysis. In this instance the first analysis will have only one column while the second will have two. So it will give an error.
Thanks i got to work.