Hello Experts
I have created crosstab report based on union query. From the final query i am trying to use two coulmns and two measures but when i introduce second column and two measure i am getting below mentioned error.
RQP-DEF-0149 The query specification is incorrect.
RQP-DEF-0469 The query 'Ethnicity+Group_tab0_sub' references the non-existent query 'AAA-BBB-CCC'.
can anybody tell what am i doing wrong?
in final query(crosstab query) i have one data item with aggregate function= count distinct and rollup aggregate function=Automatic,which is one of my measure.
i am able to put one column and two measures under the column but as son as i introduce second column, i am getting error.