cancel
Showing results for 
Search instead for 
Did you mean: 

CrossTab bottom average not showing from correctly

0 Kudos

Hi,

In the attached snapshot the average is not showing correctly as it is taking all values under all date and calculating the average instead of taking crosstab daily average to calculate the final average.

Kindly refer attached snapshot for the problem description and revert with the solution at your earliest.


- Dnyaneshwar

Accepted Solutions (0)

Answers (4)

Answers (4)

abhilash_kumar
Active Contributor
0 Kudos

Please post the formula you're using to calculate the Average.

Could you also upload a copy of the .rpt file 'with saved data' to Google drive and post the URL here?

-Abhilash

0 Kudos

I was at below step but when we insert the insert row to blank row not inserted could please help.

{

While in the Preview Mode, right-click the last date and select Calculated Member > Insert Row. Do this until you see three blank rows with zero values.

}

Regards,

Dnyaneshwar

abhilash_kumar
Active Contributor
0 Kudos
0 Kudos

I was at below step but when we insert the insert row to blank row not inserted could please help.

{

While in the Preview Mode, right-click the last date and select Calculated Member > Insert Row. Do this until you see three blank rows with zero values.

}

Regards,

Dnyaneshwar

0 Kudos

Hi Abhilash,

Could you give a solution in my case as I followed your document but the code is a calculating 1st column?

In my case, the row shall increase with date (1month date average) and I have more columns also.

So we need it dynamic check at each column bottom. Refer snapshot of report.

Thanks & Regards,

Dnyaneshwar

abhilash_kumar
Active Contributor
0 Kudos

Hi Dynaneshwar,

The correct Average should indeed be 2.2, however, if you want to calculate Average of Average, you'd need to use a Calculated member Row.

-Abhilash

0 Kudos

Hi Abhilash,

Could you please let me know, how I can use the calculated member row in my case with example if possible which shall help me.

Regards,

Dnyaneshwar