GEN-ERR-0016 'ces currentmeasure' on crosstab total

[Shamar]

Hello Gurus !!!

I am creating two queries, query1 and query2 . Then its joined with query 3.

Scenario:

Query1 and 2 is used for crosstab. query 3 is used for graph.

I need to add total in crosstab (query1 & query2). when i apply Automatic summary (or) Total , am getting the below error.

Error : The 'ces_currentmeasure' function is not supported in the context in which it is used.

But i need to show the totals in the crosstab. Please suggest a way

Datasource : Relational package
Version  : 10.2

Thanks
Shamar

[MFGF]

Hello Gurus !!!

I am creating two queries, query1 and query2 . Then its joined with query 3.

Scenario:

Query1 and 2 is used for crosstab. query 3 is used for graph.

I need to add total in crosstab (query1 & query2). when i apply Automatic summary (or) Total , am getting the below error.

Error : The 'ces_currentmeasure' function is not supported in the context in which it is used.

But i need to show the totals in the crosstab. Please suggest a way

Datasource : Relational package
Version  : 10.2

Thanks
Shamar

I think the piece you missed is in setting the aggregation property for your measure in query 3. My guess is it's set to "Unsupported" at the moment?

MF.