Query:
select je_source,to_char(date_created,'Mon-YY') Source_Month,count(je_header_id) je_count from gl_je_headerswhere to_char(date_created,'Q') = :p_quarter and to_char(date_created,'YYYY') = :p_year group
by je_source,to_char(date_created,'Mon-YY')
RDF report:
Total Number of JVs Quarterly
Source Name | Total | |
G If exists: JE_COUNT end; E | 999E | |
Total | ||
O G Close to JE_SOURCE - <?for-each- group@section:G_SERVICE_NAME;./JE_SOURCE?><?sort:JE_SOURCE;'ascending';data-type='text'?> JE_SOURCE - <?JE_SOURCE?><?variable@incontext:JS;JE_SOURCE?> G close to Source_Month : <?for-each-group@column:G_SERVICE_NAME;./SOURCE_MONTH?> Source_Month - <?SOURCE_MONTH?> E - <?end for-each-group?> G Near If Exists - <?for-each-group@cell://G_SERVICE_NAME;./SOURCE_MONTH? IF Exists – <?if:count(current-group()[JE_SOURCE=$JS])?> JE_COUNT - <?current-group()[JE_SOURCE=$JS]/JE_COUNT?> End; - <?end if?> E - <?end for-each-group?> G in Total - <?for-each-group@cell://G_SERVICE_NAME;./SOURCE_MONTH? IF Exists in Total – <?if:count(current-group())?> 999 in Total <?sum(current-group()/JE_COUNT)?> End if in Total: <?end if?> E in Total – <?end for-each-group?> 999 in Total Column - <?sum(//G_SERVICE_NAME[JE_SOURCE=$JS]/JE_COUNT)?> E in Total Column: <?end for-each-group?> |
Hi all,
ReplyDeleteIts a good post, Here I need some more info.. If we have Group above matrix This Post is not helpful. Please give some example for it. It is Helpful to every one...
Thanks & Regards,
karunakar.
It's an awesome post designed for all the web people; they will take advantage from it I am sure.
ReplyDeleteFeel free to visit my homepage: crear facebook
I do not know if it's just me or if perhaps everyone else encountering problems with your site. It appears like some of the written text on your content are running off the screen. Can someone else please comment and let me know if this is happening to them too? This could be a problem with my browser because I've
ReplyDeletehad this happen previously. Many thanks
My site revitol review
Thanks for such a great website which is helping people who is new to oracle database and Applications.Your site is very impressive and you are doing an amazing job.For more details
ReplyDeleteplease visit our website..
Oracle Cloud Fusion HCM Online Training
https://apps2fusion.com/at/64-kr/345-matrix-cross-tab-report-bi-publishe
ReplyDeletecurry 6
ReplyDeletenike shoes
balenciaga
Kanye West shoes
converse shoes
air yeezy
kd 10
off white clothing
golden goose
nike basketball shoes
air jordan
ReplyDeletekevin durant shoes
golden goose slide
supreme hoodie
jordan 6
jordan retro
jordan 1 mid
moncler coat