How to add mathematical function ??

[#1]

I have sales of 12 months but in different columns and I want to add them all in a column as Month and also wants to perform the sum of sales of that. So how can I perform ??

This is current data and wants to make chart as like this :-

[Anonymous]

Hi

You can use the cross table concept for this

Like this

[Month Sales]:

CrossTable(Month, Sales)

LOAD Department,

     Jan,

     Feb,

     Mar,

     Apr,

     May,

     Jun,

     Jul,

     Aug,

     Sep,

     Oct,

     Nov,

     Dec

FROM

[Data Files\Excel\cross table.xlsx]

(ooxml, embedded labels, table is Sheet1);

[Anonymous]

Select the Line chart and

Dimension is  Month

Expression is   Sum(Sales)

[#4]

Thanks to u all..

But I want to use without CROSS TABLE. Is any method without Cross table ????

[Anonymous]

Hi

try with the Pivot table

Dimension is  Month

Expression is   Sum(Sales)

after finish the chart  drag the month to upwards...

[#6]

Thanks..

But I want to make a line chart,, So plz suggest for that..

[Anonymous]

Take line char and add

Dimension is  Month

Expression is   Sum(Sales)

[MarcoWedel]

Why don't you want to use a crosstable load?

[#9]

Thanks to u all.. We cant use this without Cross Table..

If anyone know how to do it without Cross Table then plz tell me..

Thanks again.

[alkesh_sharma]

USe crosstable function