topic pivot chart dimensions coloring in QlikView https://community.qlik.com/t5/QlikView/pivot-chart-dimensions-coloring/m-p/213752#M67418 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I need to color the different dimensions and the subtotals of each in the respective colors.</P><P>I am doing it by setting the background color in the dimensions.I even tried out by enabling the grid view.</P><P>But my problem is i need the total row of each dimension to be displayed in one color as shown below:</P><P></P><TABLE border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-yfti-tbllook: 1184; mso-padding-alt: 0in 5.4pt 0in 5.4pt;"><TBODY><TR style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><TD style="padding-right: 5.4pt; padding-left: 5.4pt; padding-bottom: 0in; width: 0.95in; padding-top: 0in; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; border: black 1pt solid;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Product</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: black 1pt solid; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Location</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: black 1pt solid; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Seller</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: black 1pt solid; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Meaure1</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: black 1pt solid; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Meaure2</P></TD></TR><TR style="mso-yfti-irow: 1;"><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: red; padding-bottom: 0in; border-left: black 1pt solid; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">a</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #c4bc96; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: background2; mso-background-themeshade: 191;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">abc</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #8db3e2; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: text2; mso-background-themetint: 102;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">abc</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD></TR><TR style="mso-yfti-irow: 2;"><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: red; padding-bottom: 0in; border-left: black 1pt solid; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #c4bc96; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: background2; mso-background-themeshade: 191;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #8db3e2; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: text2; mso-background-themetint: 102;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">adc</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD></TR><TR style="mso-yfti-irow: 3;"><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: red; padding-bottom: 0in; border-left: black 1pt solid; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #c4bc96; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: background2; mso-background-themeshade: 191;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #c4bc96; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: background2; mso-background-themeshade: 191;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Total</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD></TR><TR style="mso-yfti-irow: 4;"><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: red; padding-bottom: 0in; border-left: black 1pt solid; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #c4bc96; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: background2; mso-background-themeshade: 191;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Total</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #c4bc96; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: background2; mso-background-themeshade: 191;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD></TR><TR style="mso-yfti-irow: 5; mso-yfti-lastrow: yes;"><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: red; padding-bottom: 0in; border-left: black 1pt solid; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Total</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: red; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: red; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD></TR></TBODY></TABLE><BR /><BR /> <P style="margin: 0in 0in 10pt;"></P><P style="margin: 0in 0in 10pt;">Currently i am getting like this:</P><P></P><TABLE border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-yfti-tbllook: 1184; mso-padding-alt: 0in 5.4pt 0in 5.4pt;"><TBODY><TR style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><TD style="padding-right: 5.4pt; padding-left: 5.4pt; padding-bottom: 0in; width: 0.95in; padding-top: 0in; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; border: black 1pt solid;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Product</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: black 1pt solid; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Location</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: black 1pt solid; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Seller</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: black 1pt solid; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Meaure1</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: black 1pt solid; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Meaure2</P></TD></TR><TR style="mso-yfti-irow: 1;"><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: red; padding-bottom: 0in; border-left: black 1pt solid; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">a</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #c4bc96; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: background2; mso-background-themeshade: 191;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">abc</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #8db3e2; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: text2; mso-background-themetint: 102;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">abc</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD></TR><TR style="mso-yfti-irow: 2;"><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: red; padding-bottom: 0in; border-left: black 1pt solid; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #c4bc96; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: background2; mso-background-themeshade: 191;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #8db3e2; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: text2; mso-background-themetint: 102;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">adc</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD></TR><TR style="mso-yfti-irow: 3;"><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: red; padding-bottom: 0in; border-left: black 1pt solid; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #c4bc96; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: background2; mso-background-themeshade: 191;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #c4bc96; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: background2; mso-background-themeshade: 191;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Total</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD></TR><TR style="mso-yfti-irow: 4;"><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: red; padding-bottom: 0in; border-left: black 1pt solid; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #c4bc96; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: background2; mso-background-themeshade: 191;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Total</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #c4bc96; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: background2; mso-background-themeshade: 191;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD></TR><TR style="mso-yfti-irow: 5; mso-yfti-lastrow: yes;"><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: red; padding-bottom: 0in; border-left: black 1pt solid; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Total</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #c4bc96; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: background2; mso-background-themeshade: 191;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #c4bc96; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: background2; mso-background-themeshade: 191;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD></TR></TBODY></TABLE><BR /><BR /> <P style="margin: 0in 0in 10pt;">Please help me to format the Pivot chart.</P><P style="margin: 0in 0in 10pt;">By enabling grid view is there any option to format each individual cell?</P><P style="margin: 0in 0in 10pt;">Urgent.</P><P style="margin: 0in 0in 10pt;">Thanks in advance.</P><P></P></BODY></HTML> Mon, 12 Oct 2009 17:38:55 GMT 2009-10-12T17:38:55Z pivot chart dimensions coloring https://community.qlik.com/t5/QlikView/pivot-chart-dimensions-coloring/m-p/213752#M67418 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I need to color the different dimensions and the subtotals of each in the respective colors.</P><P>I am doing it by setting the background color in the dimensions.I even tried out by enabling the grid view.</P><P>But my problem is i need the total row of each dimension to be displayed in one color as shown below:</P><P></P><TABLE border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-yfti-tbllook: 1184; mso-padding-alt: 0in 5.4pt 0in 5.4pt;"><TBODY><TR style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><TD style="padding-right: 5.4pt; padding-left: 5.4pt; padding-bottom: 0in; width: 0.95in; padding-top: 0in; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; border: black 1pt solid;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Product</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: black 1pt solid; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Location</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: black 1pt solid; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Seller</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: black 1pt solid; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Meaure1</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: black 1pt solid; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Meaure2</P></TD></TR><TR style="mso-yfti-irow: 1;"><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: red; padding-bottom: 0in; border-left: black 1pt solid; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">a</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #c4bc96; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: background2; mso-background-themeshade: 191;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">abc</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #8db3e2; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: text2; mso-background-themetint: 102;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">abc</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD></TR><TR style="mso-yfti-irow: 2;"><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: red; padding-bottom: 0in; border-left: black 1pt solid; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #c4bc96; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: background2; mso-background-themeshade: 191;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #8db3e2; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: text2; mso-background-themetint: 102;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">adc</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD></TR><TR style="mso-yfti-irow: 3;"><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: red; padding-bottom: 0in; border-left: black 1pt solid; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #c4bc96; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: background2; mso-background-themeshade: 191;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #c4bc96; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: background2; mso-background-themeshade: 191;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Total</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD></TR><TR style="mso-yfti-irow: 4;"><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: red; padding-bottom: 0in; border-left: black 1pt solid; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #c4bc96; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: background2; mso-background-themeshade: 191;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Total</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #c4bc96; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: background2; mso-background-themeshade: 191;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD></TR><TR style="mso-yfti-irow: 5; mso-yfti-lastrow: yes;"><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: red; padding-bottom: 0in; border-left: black 1pt solid; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Total</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: red; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: red; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD></TR></TBODY></TABLE><BR /><BR /> <P style="margin: 0in 0in 10pt;"></P><P style="margin: 0in 0in 10pt;">Currently i am getting like this:</P><P></P><TABLE border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-yfti-tbllook: 1184; mso-padding-alt: 0in 5.4pt 0in 5.4pt;"><TBODY><TR style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><TD style="padding-right: 5.4pt; padding-left: 5.4pt; padding-bottom: 0in; width: 0.95in; padding-top: 0in; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; border: black 1pt solid;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Product</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: black 1pt solid; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Location</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: black 1pt solid; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Seller</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: black 1pt solid; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Meaure1</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: black 1pt solid; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Meaure2</P></TD></TR><TR style="mso-yfti-irow: 1;"><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: red; padding-bottom: 0in; border-left: black 1pt solid; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">a</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #c4bc96; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: background2; mso-background-themeshade: 191;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">abc</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #8db3e2; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: text2; mso-background-themetint: 102;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">abc</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD></TR><TR style="mso-yfti-irow: 2;"><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: red; padding-bottom: 0in; border-left: black 1pt solid; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #c4bc96; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: background2; mso-background-themeshade: 191;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #8db3e2; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: text2; mso-background-themetint: 102;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">adc</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD></TR><TR style="mso-yfti-irow: 3;"><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: red; padding-bottom: 0in; border-left: black 1pt solid; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #c4bc96; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: background2; mso-background-themeshade: 191;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #c4bc96; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: background2; mso-background-themeshade: 191;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Total</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD></TR><TR style="mso-yfti-irow: 4;"><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: red; padding-bottom: 0in; border-left: black 1pt solid; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #c4bc96; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: background2; mso-background-themeshade: 191;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Total</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #c4bc96; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: background2; mso-background-themeshade: 191;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD></TR><TR style="mso-yfti-irow: 5; mso-yfti-lastrow: yes;"><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: red; padding-bottom: 0in; border-left: black 1pt solid; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;">Total</P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #c4bc96; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: background2; mso-background-themeshade: 191;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; background: #c4bc96; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1; mso-background-themecolor: background2; mso-background-themeshade: 191;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD><TD style="border-right: black 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0in; border-left: #d4d0c8; width: 0.95in; padding-top: 0in; border-bottom: black 1pt solid; background-color: transparent; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-right-themecolor: text1;" valign="top" width="91"><P style="margin: 0in 0in 0pt; line-height: normal;"></P></TD></TR></TBODY></TABLE><BR /><BR /> <P style="margin: 0in 0in 10pt;">Please help me to format the Pivot chart.</P><P style="margin: 0in 0in 10pt;">By enabling grid view is there any option to format each individual cell?</P><P style="margin: 0in 0in 10pt;">Urgent.</P><P style="margin: 0in 0in 10pt;">Thanks in advance.</P><P></P></BODY></HTML> Mon, 12 Oct 2009 17:38:55 GMT https://community.qlik.com/t5/QlikView/pivot-chart-dimensions-coloring/m-p/213752#M67418 2009-10-12T17:38:55Z pivot chart dimensions coloring https://community.qlik.com/t5/QlikView/pivot-chart-dimensions-coloring/m-p/213753#M67419 <HTML><HEAD></HEAD><BODY><P>Double post... please use other one!</P></BODY></HTML> Mon, 12 Oct 2009 19:41:30 GMT https://community.qlik.com/t5/QlikView/pivot-chart-dimensions-coloring/m-p/213753#M67419 2009-10-12T19:41:30Z