Displaying correct Total at the bottom

[#1]

Hi,

I am having three expression, where the third expression is (2nd Expression / 1st Expression). I am able to get the correct result for all the rows, except for the total (displayed at the bottom). I have attched the file. Is there any work around for that.

Thanks

[#2]

Hi Santhosh,

I have few doubts in you qvw.

Why the Product B has all catogories and Not for A and C. I have just tried ?

Don't this Expression product your desired output

Sum(AGGR(sum( {<Range= {'0 - 10', '11 - 20', '21 - 30', '31 - 40', '41 - 50'}>} Sales1 ),Product,Category))

[#3]

Hi Srini,

The QVW shows the top 10 categories and that is why it shows the desired result.

Your expression doesn't check for top 10 and hence it is error in the result. My problem is only in the 'Sales' expression. It doesn't give me the correct total.

Thanks