issue with straight table... need help please

[#1]

hi all,

I have a weird issue with a straight table calculation.This was already developed and I am unabe to understand regarding a particular calculation.If you see my attached file,there is a table in it which has the first row under Ship Name column."Average per month".I am not able to understand how this is calculated??? I cannot find any of its relation in expressions/dimension. my script is not complete in the attachment as I cant share the complete of it.Is this calculation happening in script level or chart level,please can someone help me???

regards,

sahana

[anbu1984]

Can you post qvw with less data or post your dimension and expr with sample data

[#3]

hi,

I have reduced the data and reattached,now can you have a look and help me out please??

regards,

sahana !

[#4]

can someone please help me with this issue??

[tresesco]

That is 'Total' - row label. Goto presentation tab->Totals...

[#6]

Hi Tresesco,

thanks!!!

but if you check in table "A",

The 1st column (Budget Avg per Ship)

  value across "average per month"= the average of the 3 values in that column and not the total.

84,513

-

87,287

-

87,287

avg=

86,362

but in the 2nd column(Budget Avg) its just the total shown=

259,086

84,513

-

87,287

-

87,287

so how is this differentiation done??? where has the formula being executed please can you help me out....??? table B also has the same but the values are not matching

[#7 · Accepted solution]

hi tresesco,

I found the solution its happening from expression tab itself.in total mode...

thanks for your response!!!

regards,

sahana

[#8]

Hi Sahana,

If you see the Total Mode in expression tab, for first expression it is Avg where as second exp has Sum. I hope you need this differentiation.

hope this helps

Amay.