Coulmn Total

[#1]

Hi All,

          I have this requirement in which i have to show calculated total (formula- Ex-=(Sum of OFE – Sum of Error) / Sum of OFE)total at botton of each coulmn,Like for Apr-2014 may 2014 2014-2015 total should be according to the formula above ??

[vardhancse]

Yes for pivot table, this option will be disabled.

Try to convert in to straight table

[vardhancse]

In this pivot table, we need to align the field names so that it will come in proper way.

Like drag the fields from row to column

[#4]

yes i did try this method

[#5]

but its giving me output as

[vardhancse]

drag and drop the rows and columns properly

[SunilChauhan]

see the attched example

hope this helps

[#8]

hi sasi i tried but am not able to get Total column at the bottom ,how to do that?

[vardhancse]

Hi Rohit,

Select Totals on Last Row, u can able to see the total in the last row.

Or

In the chart properties->presentation

Select select Show Partial Sums for the dimensions

[#10]

Hello Guys , I want Only Grand total which an expression as total, at the bottom and not the count,grand total as shown in image below in month column,how do i do that,i have also attached sample.qvw in documents kindly check and let me know.