Num of colum with and without data

[#1]

I need to reproduce the execel that i atach.

I need know hoe to calculate Num Month, and Nun Month data

Basically num month will count num of month by year, and num month data count the num of month dhata have data.

Thanks in advance.

[MK_QSL]

How's your actual data. If they are as per the excel file, it's difficult to work.

[sujeetsingh]

Explain in detail plz

[#4]

I HAVE MY DATA IN A ORACLE TABLE.

TO BE SIMPLE I HAVE IN A PIVOT TABLE.

DIMENSION.

YEAR

MONTH

CONTACT

AND EXPRESSION

SUM(SALES1 +SALES2 + SALES3)

I can do all the excel expect to column i am asking. Num of month and num of month with data.

Regards

[MK_QSL]

Can you provide data in excel file as per mentioned above...

[er_mohit]

Try this code in text object

here, my blank field name which having value also is Data

=count(if(len(Data)>0,Data))

or to count num month

Try this

=count(Month)

[#7]

Here the example.!!

Thanks!

[bertdijks]

For the number of months with data:

=NumericCount(data)

for the number of months in year

=count( MONTH)

[#9]

how do you put in that specific side in the pivot table?

[mato32188]

Hi, try this.