Hello Guys.
I have the following issue.
I have a query that shows in rows a herarchie characteristic with several positions, and in columns I have 2 ratios, one has the value of the month that the user selects, and the other is the same ratio but filtered by month = 12 and year = 2005.
I want this last ratio to be constant and show always the values for month 12 and year 2005. But when the user is navigating in the WAD, and change the current month, the second ratio is not showing any data.
If I put constant selection in second ratio, it shows the total amount, but i want the amount corresponding to each position (the positions that are in characteristic in rows).
How can I do this issue
thanks in advance.