Help in cognos filtering
Posted on 2013-01-23
I have a cross tab report where I need to show data for current quarter as one column and whole year as another cross tab column . But it is not working, can anyone please give me some ideas on this..
Not working means, for example to get Quarter data I did a calculated data item as:
[action_date]>= 2012-10-01 and [action_date]<2013-01-01
when I pull this into my crosstab column area I get an error as
OP-ERR-0046 Unable to support query items from the same dimension on different report dimensions: dimension="[MEASURES]"; edge="axis(0)"; edge="axis(1)".