Row wise customized total in straight table.

naushad786 · ‎2013-12-06

There is any solution to do customized total in straight table.

Straight table provide the total of all columns that exist by default, but my need is do the total condition wise. Can anyone help?

Anonymous · ‎2013-12-09

Hi Naushad,

Just try to drag week dimension to the top of the columns, and you will definately get your formt.

naushad786 · ‎2013-12-09

Nitin thanks. now the format is same which i need. but how can i do the condition wise total in last row.

kiranmanoharrode · ‎2013-12-09

Dear Naushad,

can u post the sample application??? it will be helpful to understand and solve your problem.

Anonymous · ‎2013-12-09

Try Subtotals in Presentation Tab of properties of the chart object

naushad786 · ‎2013-12-09

Dear Kiran,

naushad786 · ‎2013-12-09

i want to do subtotal condition wise. is it possible?..

Anonymous · ‎2013-12-10

On what conditions you want the totals.

Actually, we can do a subtotal only based on dimension values , therefore you are able to sum up the week values.

If some conditions are to be applied, we have to have more dimension for that.

Please tell me on what condition you need totals.

Regards

Nitin

naushad786 · ‎2013-12-10

Like this

Anonymous · ‎2013-12-11

If this type of conditions will be applied, so I think you will be having multiple MTD column,

as you want to sum up Budget and Forecast for week 44,

and others also...

I think it would not be possible.

One solution can be , you can use text boxes for showing specific totals.