topic Pivot Table subtotals using calculated dimensions in QlikView

topic Pivot Table subtotals using calculated dimensions in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-subtotals-using-calculated-dimensions/m-p/554100#M1143851 <HTML><HEAD></HEAD><BODY><P>Dear All</P><P></P><P>I have checked quite a few feeds but can't find exactly what I'm looking for.</P><P></P><P>I have a pivot table and I have calculated dimensions to create  subtotals for the selected records</P><P>The calculated dimension do what I need but I would like to remove the extra columns and just display the subtotals, is this possible? </P><P> in the example below it's the first 2 columns...i;ve messed up the data so total won't be correct in the sample..</P><P></P><P>.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0"><TBODY><TR><TD class="xl65" height="17" width="167">=<BR />  Left(CostCode, 1) = 'Y'</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="151">=(CostCode =<BR />  'YBED')</TD><TD class="xl66" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="178">Cost Centre</TD><TD class="xl67" width="117">FORECAST 2013</TD><TD class="xl67" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="108">BUDGET 2013</TD><TD class="xl67" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="108">ACTUAL 2012</TD><TD class="xl67" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="103">ACTUAL 2013</TD><TD class="xl67" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="112">% Diff Vs Budget</TD><TD class="xl67" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="127">% Diff Vs Last<BR />  Year</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;"><BR />  Cambridge</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;"><BR />  London</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Language Centre</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">TTC Homerton</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Delta/OnLine</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">MISSING</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl71" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">Total</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£600.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£600.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£600.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£600.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">0</TD><TD class="xl73" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">Total</TD><TD class="xl71" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;"> </TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£1,100.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£1,100.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£1,100.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£1,100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">-1</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">YL Ardingly</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">-1</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">YL Bloxham</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">-1</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">YL Bowles</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">-1</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">YL Christmas Course</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">-1</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">YL Closed Groups</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">-1</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">YL Cobham</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">-1</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">YL Grosvenor Hall</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">-1</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">YL Leys</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">-1</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">YL St Albans</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">-1</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">YL Wellington</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">-1</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl71" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">Total</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£1,000.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£1,000.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£1,000.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£1,000.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">-1</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-1</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">YL Bedgebury</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">-1</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-1</TD><TD class="xl71" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">Total</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">-1</TD><TD class="xl73" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">Total</TD><TD class="xl71" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;"> </TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£600.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£600.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£600.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£600.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl74" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">Total</TD><TD class="xl73" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;"> </TD><TD class="xl71" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;"> </TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£600.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£600.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£600.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£600.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 30 Aug 2013 14:01:25 GMT 2013-08-30T14:01:25Z Pivot Table subtotals using calculated dimensions https://community.qlik.com/t5/QlikView/Pivot-Table-subtotals-using-calculated-dimensions/m-p/554100#M1143851 <HTML><HEAD></HEAD><BODY><P>Dear All</P><P></P><P>I have checked quite a few feeds but can't find exactly what I'm looking for.</P><P></P><P>I have a pivot table and I have calculated dimensions to create  subtotals for the selected records</P><P>The calculated dimension do what I need but I would like to remove the extra columns and just display the subtotals, is this possible? </P><P> in the example below it's the first 2 columns...i;ve messed up the data so total won't be correct in the sample..</P><P></P><P>.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0"><TBODY><TR><TD class="xl65" height="17" width="167">=<BR />  Left(CostCode, 1) = 'Y'</TD><TD class="xl65" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="151">=(CostCode =<BR />  'YBED')</TD><TD class="xl66" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="178">Cost Centre</TD><TD class="xl67" width="117">FORECAST 2013</TD><TD class="xl67" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="108">BUDGET 2013</TD><TD class="xl67" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="108">ACTUAL 2012</TD><TD class="xl67" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="103">ACTUAL 2013</TD><TD class="xl67" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="112">% Diff Vs Budget</TD><TD class="xl67" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="127">% Diff Vs Last<BR />  Year</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;"><BR />  Cambridge</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;"><BR />  London</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Language Centre</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">TTC Homerton</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">Delta/OnLine</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">MISSING</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl71" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">Total</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£600.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£600.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£600.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£600.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">0</TD><TD class="xl73" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">Total</TD><TD class="xl71" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;"> </TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£1,100.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£1,100.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£1,100.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£1,100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">-1</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">YL Ardingly</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">-1</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">YL Bloxham</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">-1</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">YL Bowles</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">-1</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">YL Christmas Course</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">-1</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">YL Closed Groups</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">-1</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">YL Cobham</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">-1</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">YL Grosvenor Hall</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">-1</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">YL Leys</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">-1</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">YL St Albans</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">-1</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">YL Wellington</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">-1</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0</TD><TD class="xl71" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">Total</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£1,000.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£1,000.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£1,000.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£1,000.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">-1</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-1</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">YL Bedgebury</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl68" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">-1</TD><TD class="xl67" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-1</TD><TD class="xl71" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">Total</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£100.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl67" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">-1</TD><TD class="xl73" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">Total</TD><TD class="xl71" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;"> </TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£600.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£600.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£600.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£600.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR><TR><TD class="xl74" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">Total</TD><TD class="xl73" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;"> </TD><TD class="xl71" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;"> </TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£600.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£600.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£600.00</TD><TD align="right" class="xl72" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">£600.00</TD><TD align="right" class="xl69" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">0.00%</TD><TD align="right" class="xl70" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">-0.12%</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 30 Aug 2013 14:01:25 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-subtotals-using-calculated-dimensions/m-p/554100#M1143851 2013-08-30T14:01:25Z