Merge rows with same column header


(system) #1
Try this, however you will show 0s instead of null.  I think this might fix the issue.

SUM(case when Month(PartTran.TranDate)=1  then PartTran.ExtCost else 0 end)



(system) #2
probably easier if you build the results witha  bpm and place everything on a UD table and then just report from there. 
 
Kind Regards,
Sergio P. 
CTO, Sr. Partner

Mayan Technologies USA, Inc.
(858) 900.1555
sprieto@...



On Thursday, September 8, 2016 9:31 AM, "don.n.doan@... [vantage]" <vantage@yahoogroups.com> wrote:


 
<div id="ygrps-yiv-667384669yiv0329815135ygrp-text">
  
  
  <div>Try this, however you will show 0s instead of null. &nbsp;I think this might fix the issue.</div><div><br clear="none"></div><div><div dir="ltr" id="ygrps-yiv-667384669yiv0329815135ygrps-yiv-1598714030yui_3_16_0_ym19_1_1473187682705_9132" style="font-size:16px;">SUM(case when Month(PartTran.TranDate)=1&nbsp; then PartTran.ExtCost else 0 end)</div><div><br clear="none"></div></div><div><br clear="none"></div>

</div>
 


<div style="color:#fff;min-height:0;"></div></div>
#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135 -- #ygrps-yiv-667384669yiv0329815135ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135ygrp-mkp #ygrps-yiv-667384669yiv0329815135hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135ygrp-mkp #ygrps-yiv-667384669yiv0329815135ads {
margin-bottom:10px;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135ygrp-mkp .ygrps-yiv-667384669yiv0329815135ad {
padding:0 0;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135ygrp-mkp .ygrps-yiv-667384669yiv0329815135ad p {
margin:0;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135ygrp-mkp .ygrps-yiv-667384669yiv0329815135ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135ygrp-sponsor #ygrps-yiv-667384669yiv0329815135ygrp-lc {
font-family:Arial;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135ygrp-sponsor #ygrps-yiv-667384669yiv0329815135ygrp-lc #ygrps-yiv-667384669yiv0329815135hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135ygrp-sponsor #ygrps-yiv-667384669yiv0329815135ygrp-lc .ygrps-yiv-667384669yiv0329815135ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135activity span {
font-weight:700;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135activity span span {
color:#ff7900;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135activity span .ygrps-yiv-667384669yiv0329815135underline {
text-decoration:underline;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 .ygrps-yiv-667384669yiv0329815135attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 .ygrps-yiv-667384669yiv0329815135attach div a {
text-decoration:none;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 .ygrps-yiv-667384669yiv0329815135attach img {
border:none;padding-right:5px;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 .ygrps-yiv-667384669yiv0329815135attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 .ygrps-yiv-667384669yiv0329815135attach label a {
text-decoration:none;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 .ygrps-yiv-667384669yiv0329815135bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 .ygrps-yiv-667384669yiv0329815135bold a {
text-decoration:none;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 dd.ygrps-yiv-667384669yiv0329815135last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 dd.ygrps-yiv-667384669yiv0329815135last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 dd.ygrps-yiv-667384669yiv0329815135last p span.ygrps-yiv-667384669yiv0329815135yshortcuts {
margin-right:0;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 div.ygrps-yiv-667384669yiv0329815135attach-table div div a {
text-decoration:none;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 div.ygrps-yiv-667384669yiv0329815135attach-table {
width:400px;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 div.ygrps-yiv-667384669yiv0329815135file-title a, #ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 div.ygrps-yiv-667384669yiv0329815135file-title a:active, #ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 div.ygrps-yiv-667384669yiv0329815135file-title a:hover, #ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 div.ygrps-yiv-667384669yiv0329815135file-title a:visited {
text-decoration:none;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 div.ygrps-yiv-667384669yiv0329815135photo-title a, #ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 div.ygrps-yiv-667384669yiv0329815135photo-title a:active, #ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 div.ygrps-yiv-667384669yiv0329815135photo-title a:hover, #ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 div.ygrps-yiv-667384669yiv0329815135photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 div#ygrps-yiv-667384669yiv0329815135ygrp-mlmsg #ygrps-yiv-667384669yiv0329815135ygrp-msg p a span.ygrps-yiv-667384669yiv0329815135yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 .ygrps-yiv-667384669yiv0329815135green {
color:#628c2a;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 .ygrps-yiv-667384669yiv0329815135MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 o {
font-size:0;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135photos div {
float:left;width:72px;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135photos div div {
border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135reco-category {
font-size:77%;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135reco-desc {
font-size:77%;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 .ygrps-yiv-667384669yiv0329815135replbq {
margin:4px;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135ygrp-mlmsg select, #ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 input, #ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135ygrp-mlmsg pre, #ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 code {
font:115% monospace;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135ygrp-mlmsg #ygrps-yiv-667384669yiv0329815135logo {
padding-bottom:10px;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135ygrp-msg p#ygrps-yiv-667384669yiv0329815135attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135ygrp-reco #ygrps-yiv-667384669yiv0329815135reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135ygrp-sponsor #ygrps-yiv-667384669yiv0329815135ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135ygrp-sponsor #ygrps-yiv-667384669yiv0329815135ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135ygrp-sponsor #ygrps-yiv-667384669yiv0329815135ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135ygrp-text {
font-family:Georgia;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135ygrp-text tt {
font-size:120%;}

#ygrps-yiv-667384669 #ygrps-yiv-667384669yiv0329815135 #ygrps-yiv-667384669yiv0329815135ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-667384669




(system) #3
I want to show how much ExtCost which is from filed PartTran.ExtCost calculated by month.
the result I expect would be like this:

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
PartNum1 77.46     96.64     50.36       38.5

I used pivot to get the first row label ( the month), Did Sum calculation of ExtCost to get total monthly cost,

calculation field is:

case when Month(PartTran.TranDate)=1  then Sum(PartTran.ExtCost) else NULL end

which needed to be grouped by   PartTran.Company,   PartTranPartNum,   PartTran.TranDate

However, the result I got is shown as follow
Is there any way to merge these rows because they are all belong to PartNum1?

Thanks all,

Xiaoting,
Email:gengxt@...

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
PartNum1                     38.5
PartNum1             50.36        
PartNum1       96.64              
PartNum1 77.46                  
 

(system) #4
Hi,
You can try to add a total field outside your TranDate grouping or remove the PartTran.TrandDate from your table grouping, 
so the rows can sum by PartNum1. Since the date is different for each ExtCost, the PartNum1 is splitting for each one.
 
Dora Chavarria   Sr. Consultant Analysis Services, ERP   Mayan Technologies USA, Inc. dchavarria@... www.mayantechs.com 

(system) #5
Thank you, but what if we want to use transaction date as a filter, if there are two transaction record in same month but different year, can we show some information about year?

Is there any possible if we don't pick up PatyTran.TranDate in BAQs top level, but can show in dashboard?

the result like this or other format: in general , let users know the cost is sum of two record.

 
date range:2015.1-2016.8 there are two transaction record in 2015.3 and 2016.3, we show the two record separately.
Part January February March April May June July August September October November December
PartNum1     50  20       25       236    

Thanks again

Sincerely,
Xiaoting

Sent from Yahoo Mail. Get the app


On Wednesday, September 7, 2016 12:26 PM, "Dora Chavarria dorachavarria87@... [vantage]" <vantage@yahoogroups.com> wrote:


 
<div id="ygrps-yiv-359921594yiv9038748437ygrp-text">
  
  
  <div></div><div style="color:#000;background-color:#fff;font-family:HelveticaNeue-Light, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"><div id="ygrps-yiv-359921594yiv9038748437yui_3_16_0_ym19_1_1473266841895_39827">Hi,</div><div id="ygrps-yiv-359921594yiv9038748437yui_3_16_0_ym19_1_1473266841895_39828">You can try to add a total field outside your TranDate grouping or remove the PartTran.TrandDate from your table grouping,&nbsp;</div><div id="ygrps-yiv-359921594yiv9038748437yui_3_16_0_ym19_1_1473266841895_39822"></div><div id="ygrps-yiv-359921594yiv9038748437yui_3_16_0_ym19_1_1473266841895_39829" dir="ltr">so the rows can sum by PartNum1. Since the date is different for each ExtCost, the PartNum1 is splitting for each one.</div><div></div><div id="ygrps-yiv-359921594yiv9038748437yui_3_16_0_ym19_1_1473266841895_39821">&nbsp;</div><div class="ygrps-yiv-359921594yiv9038748437signature" id="ygrps-yiv-359921594yiv9038748437yui_3_16_0_ym19_1_1473266841895_39820">Dora Chavarria &nbsp;

Sr. Consultant Analysis Services, ERP  
Mayan Technologies USA, Inc. dchavarria@… www.mayantechs.com 

</div>
 


<div style="color:#fff;min-height:0;"></div></div>
#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437 -- #ygrps-yiv-359921594yiv9038748437ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437ygrp-mkp #ygrps-yiv-359921594yiv9038748437hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437ygrp-mkp #ygrps-yiv-359921594yiv9038748437ads {
margin-bottom:10px;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437ygrp-mkp .ygrps-yiv-359921594yiv9038748437ad {
padding:0 0;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437ygrp-mkp .ygrps-yiv-359921594yiv9038748437ad p {
margin:0;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437ygrp-mkp .ygrps-yiv-359921594yiv9038748437ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437ygrp-sponsor #ygrps-yiv-359921594yiv9038748437ygrp-lc {
font-family:Arial;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437ygrp-sponsor #ygrps-yiv-359921594yiv9038748437ygrp-lc #ygrps-yiv-359921594yiv9038748437hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437ygrp-sponsor #ygrps-yiv-359921594yiv9038748437ygrp-lc .ygrps-yiv-359921594yiv9038748437ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437activity span {
font-weight:700;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437activity span span {
color:#ff7900;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437activity span .ygrps-yiv-359921594yiv9038748437underline {
text-decoration:underline;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 .ygrps-yiv-359921594yiv9038748437attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 .ygrps-yiv-359921594yiv9038748437attach div a {
text-decoration:none;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 .ygrps-yiv-359921594yiv9038748437attach img {
border:none;padding-right:5px;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 .ygrps-yiv-359921594yiv9038748437attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 .ygrps-yiv-359921594yiv9038748437attach label a {
text-decoration:none;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 .ygrps-yiv-359921594yiv9038748437bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 .ygrps-yiv-359921594yiv9038748437bold a {
text-decoration:none;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 dd.ygrps-yiv-359921594yiv9038748437last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 dd.ygrps-yiv-359921594yiv9038748437last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 dd.ygrps-yiv-359921594yiv9038748437last p span.ygrps-yiv-359921594yiv9038748437yshortcuts {
margin-right:0;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 div.ygrps-yiv-359921594yiv9038748437attach-table div div a {
text-decoration:none;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 div.ygrps-yiv-359921594yiv9038748437attach-table {
width:400px;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 div.ygrps-yiv-359921594yiv9038748437file-title a, #ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 div.ygrps-yiv-359921594yiv9038748437file-title a:active, #ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 div.ygrps-yiv-359921594yiv9038748437file-title a:hover, #ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 div.ygrps-yiv-359921594yiv9038748437file-title a:visited {
text-decoration:none;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 div.ygrps-yiv-359921594yiv9038748437photo-title a, #ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 div.ygrps-yiv-359921594yiv9038748437photo-title a:active, #ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 div.ygrps-yiv-359921594yiv9038748437photo-title a:hover, #ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 div.ygrps-yiv-359921594yiv9038748437photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 div#ygrps-yiv-359921594yiv9038748437ygrp-mlmsg #ygrps-yiv-359921594yiv9038748437ygrp-msg p a span.ygrps-yiv-359921594yiv9038748437yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 .ygrps-yiv-359921594yiv9038748437green {
color:#628c2a;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 .ygrps-yiv-359921594yiv9038748437MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 o {
font-size:0;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437photos div {
float:left;width:72px;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437photos div div {
border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437reco-category {
font-size:77%;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437reco-desc {
font-size:77%;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 .ygrps-yiv-359921594yiv9038748437replbq {
margin:4px;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437ygrp-mlmsg select, #ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 input, #ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437ygrp-mlmsg pre, #ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 code {
font:115% monospace;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437ygrp-mlmsg #ygrps-yiv-359921594yiv9038748437logo {
padding-bottom:10px;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437ygrp-msg p#ygrps-yiv-359921594yiv9038748437attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437ygrp-reco #ygrps-yiv-359921594yiv9038748437reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437ygrp-sponsor #ygrps-yiv-359921594yiv9038748437ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437ygrp-sponsor #ygrps-yiv-359921594yiv9038748437ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437ygrp-sponsor #ygrps-yiv-359921594yiv9038748437ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437ygrp-text {
font-family:Georgia;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437ygrp-text tt {
font-size:120%;}

#ygrps-yiv-359921594 #ygrps-yiv-359921594yiv9038748437 #ygrps-yiv-359921594yiv9038748437ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-359921594




(system) #6
Even if the information is not being grouped by TranDate you can sure use that field as a filter.
If what you are trying to accomplish is to display the ExtCost per year you can create a calculated field such as:  Year(PartTran.TranDate)
and use this field in your grouping.
 


Dora Chavarria   Sr. Consultant Analysis Services, ERP   Mayan Technologies USA, Inc. dchavarria@... www.mayantechs.com 


On Wednesday, September 7, 2016 2:42 PM, "gengxt@... [vantage]" <vantage@yahoogroups.com> wrote:


 
<div id="ygrps-yiv-1772454255yiv0493731978ygrp-text">
  
  
  <div></div><div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"><div><span></span></div><div id="ygrps-yiv-1772454255yiv0493731978yui_3_16_0_ym19_1_1473281981331_3418">Thank you, but what if we&nbsp;want to use&nbsp;transaction date as a filter, if there are two transaction record in same month but different year, can we show&nbsp;some information about year?</div><div id="ygrps-yiv-1772454255yiv0493731978yui_3_16_0_ym19_1_1473281981331_4075"><br clear="none"></div><div id="ygrps-yiv-1772454255yiv0493731978yui_3_16_0_ym19_1_1473281981331_4079">Is there any possible if we don&#39;t pick up PatyTran.TranDate in BAQs top level, but can show in dashboard?</div><div id="ygrps-yiv-1772454255yiv0493731978yui_3_16_0_ym19_1_1473281981331_3417"><br clear="none"></div><div dir="ltr" id="ygrps-yiv-1772454255yiv0493731978yui_3_16_0_ym19_1_1473281981331_3416">the result like this or other format: in general , let users know the cost is sum of two record.</div><div dir="ltr" id="ygrps-yiv-1772454255yiv0493731978yui_3_16_0_ym19_1_1473281981331_3415"><br clear="none"></div><div dir="ltr" id="ygrps-yiv-1772454255yiv0493731978yui_3_16_0_ym19_1_1473281981331_3422">&nbsp;</div><table id="ygrps-yiv-1772454255yiv0493731978yui_3_16_0_ym19_1_1473281981331_3591" width="960" style="border-collapse:collapse;width:720pt;" border="1" cellspacing="0" cellpadding="0"><colgroup span="1" id="ygrps-yiv-1772454255yiv0493731978yui_3_16_0_ym19_1_1473281981331_3592"><col span="1" id="ygrps-yiv-1772454255yiv0493731978yui_3_16_0_ym19_1_1473281981331_3593" width="192" style="width:144pt;"><col span="12" id="ygrps-yiv-1772454255yiv0493731978yui_3_16_0_ym19_1_1473281981331_3594" width="64" style="width:48pt;"></colgroup><tbody id="ygrps-yiv-1772454255yiv0493731978yui_3_16_0_ym19_1_1473281981331_3595"><tr id="ygrps-yiv-1772454255yiv0493731978yui_3_16_0_ym19_1_1473281981331_3596" height="20" style="min-height:15.0pt;"><td colspan="1" rowspan="1" id="ygrps-yiv-1772454255yiv0493731978yui_3_16_0_ym19_1_1473281981331_3597" width="192" height="20" style="width:144pt;min-height:15pt;background-color:transparent;"><font id="ygrps-yiv-1772454255yiv0493731978yui_3_16_0_ym19_1_1473281981331_3598" face="Calibri">date

range:2015.1-2016.8

there are two
transaction record in 2015.3 and 2016.3, we show the two record separately. Part January February March April May June July August September October November December PartNum1     50 
20       25       236    

Thanks again

Sincerely,
Xiaoting

Sent from Yahoo Mail. Get the app


On Wednesday, September 7, 2016 12:26 PM, “Dora Chavarria dorachavarria87@… [vantage]” <vantage@yahoogroups.com> wrote:



 
<div id="ygrps-yiv-1772454255yiv0493731978ygrp-text">
  
  
  <div></div><div style="color:#000;background-color:#fff;font-family:HelveticaNeue-Light, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"><div id="ygrps-yiv-1772454255yiv0493731978yui_3_16_0_ym19_1_1473266841895_39827">Hi,</div><div id="ygrps-yiv-1772454255yiv0493731978yui_3_16_0_ym19_1_1473266841895_39828">You can try to add a total field outside your TranDate grouping or remove the PartTran.TrandDate from your table grouping,&nbsp;</div><div id="ygrps-yiv-1772454255yiv0493731978yui_3_16_0_ym19_1_1473266841895_39822"></div><div dir="ltr" id="ygrps-yiv-1772454255yiv0493731978yui_3_16_0_ym19_1_1473266841895_39829">so the rows can sum by PartNum1. Since the date is different for each ExtCost, the PartNum1 is splitting for each one.</div><div></div><div id="ygrps-yiv-1772454255yiv0493731978yui_3_16_0_ym19_1_1473266841895_39821">&nbsp;</div><div class="ygrps-yiv-1772454255yiv0493731978signature" id="ygrps-yiv-1772454255yiv0493731978yui_3_16_0_ym19_1_1473266841895_39820">Dora Chavarria &nbsp;

Sr. Consultant Analysis Services, ERP  
Mayan Technologies USA, Inc. dchavarria@… www.mayantechs.com 

</div>
 


<div style="color:#fff;min-height:0;"></div></div>


</div>
 


<div class="ygrps-yiv-1772454255yiv0493731978yqt2362883499" id="ygrps-yiv-1772454255yiv0493731978yqt34171"><div style="color:#fff;min-height:0;"></div></div>
#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978 -- #ygrps-yiv-1772454255yiv0493731978ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978ygrp-mkp #ygrps-yiv-1772454255yiv0493731978hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978ygrp-mkp #ygrps-yiv-1772454255yiv0493731978ads {
margin-bottom:10px;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978ygrp-mkp .ygrps-yiv-1772454255yiv0493731978ad {
padding:0 0;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978ygrp-mkp .ygrps-yiv-1772454255yiv0493731978ad p {
margin:0;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978ygrp-mkp .ygrps-yiv-1772454255yiv0493731978ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978ygrp-sponsor #ygrps-yiv-1772454255yiv0493731978ygrp-lc {
font-family:Arial;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978ygrp-sponsor #ygrps-yiv-1772454255yiv0493731978ygrp-lc #ygrps-yiv-1772454255yiv0493731978hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978ygrp-sponsor #ygrps-yiv-1772454255yiv0493731978ygrp-lc .ygrps-yiv-1772454255yiv0493731978ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978activity span {
font-weight:700;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978activity span span {
color:#ff7900;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978activity span .ygrps-yiv-1772454255yiv0493731978underline {
text-decoration:underline;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 .ygrps-yiv-1772454255yiv0493731978attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 .ygrps-yiv-1772454255yiv0493731978attach div a {
text-decoration:none;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 .ygrps-yiv-1772454255yiv0493731978attach img {
border:none;padding-right:5px;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 .ygrps-yiv-1772454255yiv0493731978attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 .ygrps-yiv-1772454255yiv0493731978attach label a {
text-decoration:none;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 .ygrps-yiv-1772454255yiv0493731978bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 .ygrps-yiv-1772454255yiv0493731978bold a {
text-decoration:none;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 dd.ygrps-yiv-1772454255yiv0493731978last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 dd.ygrps-yiv-1772454255yiv0493731978last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 dd.ygrps-yiv-1772454255yiv0493731978last p span.ygrps-yiv-1772454255yiv0493731978yshortcuts {
margin-right:0;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 div.ygrps-yiv-1772454255yiv0493731978attach-table div div a {
text-decoration:none;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 div.ygrps-yiv-1772454255yiv0493731978attach-table {
width:400px;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 div.ygrps-yiv-1772454255yiv0493731978file-title a, #ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 div.ygrps-yiv-1772454255yiv0493731978file-title a:active, #ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 div.ygrps-yiv-1772454255yiv0493731978file-title a:hover, #ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 div.ygrps-yiv-1772454255yiv0493731978file-title a:visited {
text-decoration:none;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 div.ygrps-yiv-1772454255yiv0493731978photo-title a, #ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 div.ygrps-yiv-1772454255yiv0493731978photo-title a:active, #ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 div.ygrps-yiv-1772454255yiv0493731978photo-title a:hover, #ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 div.ygrps-yiv-1772454255yiv0493731978photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 div#ygrps-yiv-1772454255yiv0493731978ygrp-mlmsg #ygrps-yiv-1772454255yiv0493731978ygrp-msg p a span.ygrps-yiv-1772454255yiv0493731978yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 .ygrps-yiv-1772454255yiv0493731978green {
color:#628c2a;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 .ygrps-yiv-1772454255yiv0493731978MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 o {
font-size:0;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978photos div {
float:left;width:72px;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978photos div div {
border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978reco-category {
font-size:77%;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978reco-desc {
font-size:77%;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 .ygrps-yiv-1772454255yiv0493731978replbq {
margin:4px;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978ygrp-mlmsg select, #ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 input, #ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978ygrp-mlmsg pre, #ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 code {
font:115% monospace;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978ygrp-mlmsg #ygrps-yiv-1772454255yiv0493731978logo {
padding-bottom:10px;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978ygrp-msg p#ygrps-yiv-1772454255yiv0493731978attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978ygrp-reco #ygrps-yiv-1772454255yiv0493731978reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978ygrp-sponsor #ygrps-yiv-1772454255yiv0493731978ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978ygrp-sponsor #ygrps-yiv-1772454255yiv0493731978ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978ygrp-sponsor #ygrps-yiv-1772454255yiv0493731978ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978ygrp-text {
font-family:Georgia;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978ygrp-text tt {
font-size:120%;}

#ygrps-yiv-1772454255 #ygrps-yiv-1772454255yiv0493731978 #ygrps-yiv-1772454255yiv0493731978ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-1772454255