Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Here you have without aggr
In previous version i loaded null records. This is why i had aggr.
How's your actual data. If they are as per the excel file, it's difficult to work.
Explain in detail plz
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
Can you provide data in excel file as per mentioned above...
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)
Here the example.!!
Thanks!
For the number of months with data:
=NumericCount(data)
for the number of months in year
=count( MONTH)
how do you put in that specific side in the pivot table?
Hi, try this.