total in straight table

[#1]

Hi,

I have a straight table that shows the top 50 SKUs. Here's the image:

When I show the total FY201 and FY2011 columns give me the correct totals but the total in %Change, %YAGO and %Share doesn't give me the correct total. I want to show the total of 50 SKUs.. How can I do this?

[CELAMBARASAN]

Hi,

     Change the option to that expression Sum of rows.

     Chart Properties-->Expression Tab-->Under Total Mode Check the Sum of rows.

Celambarasan

[#3]

I already used that option, still gives me the wrong output

[CELAMBARASAN]

Hi,

     Can you post your expression ?

Celambarasan

[jagan]

Hi,

What are your percentage expressions?

Try using

=Sum(Your Percentage expression here)

and select Chart Properties-->Expression Tab-->Under Total Mode Check the Sum of rows.

Hope it helps you.

Regards,

Jagan.

[#6]

here are my Percentage expressions:

For,

%Change:

( Sum({<fin_year={$(vMaxFinYear)}>}extended_price) - Sum({<fin_year={$(vPrevFinYear)}>}extended_price) )

/ Sum({<fin_year={$(vPrevFinYear)}>}extended_price)

%YAGO:

Sum({<fin_year={$(vMaxFinYear)}>}extended_price) / Sum({<fin_year={$(vPrevFinYear)}>}extended_price)

%Share:

Sum({$<fin_year={$(vMaxFinYear)}>}extended_price) / Sum(TOTAL extended_price)

[#7]

can somebody help me??

[#8]

[CELAMBARASAN]

Hi,

     Try your expression as

     if(Rowno()>0,

( Sum({<fin_year={$(vMaxFinYear)}>}extended_price) - Sum({<fin_year={$(vPrevFinYear)}>}extended_price) )

/ Sum({<fin_year={$(vPrevFinYear)}>}extended_price),

( Sum(TOTAL {<fin_year={$(vMaxFinYear)}>}extended_price) - Sum( TOTAL {<fin_year={$(vPrevFinYear)}>}extended_price) )/Sum(TOTAL {<fin_year={$(vPrevFinYear)}>}extended_price))

Celambarasan

[#10]

It still gives me the wrong output