topic Pivot table in QlikView https://community.qlik.com/t5/QlikView/Pivot-table/m-p/1287236#M402934 <HTML><HEAD></HEAD><BODY><P>I have the&nbsp; pivot table:</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 705px;"><TBODY><TR><TD class="xl63" height="17" width="54">Division</TD><TD class="xl64" style="border-left: none;" width="105">FinMounth</TD><TD class="xl65" width="103">Revenues 2017</TD><TD class="xl65" style="border-left: none;" width="103">Revenues 2016</TD><TD class="xl65" style="border-left: none;" width="112">Cumulative 2017</TD><TD class="xl65" style="border-left: none;" width="82">Plan 2017</TD><TD class="xl65" style="border-left: none;" width="51">after-admision</TD><TD class="xl65" style="border-left: none;" width="95">Change 16-17</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA</TD><TD class="xl66" style="border-top: none; border-left: none;">Jan</TD><TD align="right" class="xl68">148 025 €</TD><TD align="right" class="xl68">112 067 €</TD><TD align="right" class="xl68">148 025 €</TD><TD align="right" class="xl68">158 333 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-10 309€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA</TD><TD class="xl66" style="border-top: none; border-left: none;">Feb</TD><TD align="right" class="xl68">127 924 €</TD><TD align="right" class="xl68">163 539 €</TD><TD align="right" class="xl68">275 948 €</TD><TD align="right" class="xl68">316 666 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-40 718€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA</TD><TD class="xl66" style="border-top: none; border-left: none;">Mar</TD><TD align="right" class="xl68">19 124 €</TD><TD align="right" class="xl68">177 144 €</TD><TD align="right" class="xl68">295 072 €</TD><TD align="right" class="xl68">475 000 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-179 927€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA</TD><TD class="xl66" style="border-top: none; border-left: none;">Apr</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">152 992 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">633 333 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-633 333€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA</TD><TD class="xl66" style="border-top: none; border-left: none;">Máj</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">160 683 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">791 666 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-791 666€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA</TD><TD class="xl66" style="border-top: none; border-left: none;">Jún</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">122 923 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">949 999 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-949 999€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA</TD><TD class="xl66" style="border-top: none; border-left: none;">Júl</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">107 776 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">1 108 332 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-1 108 332€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA</TD><TD class="xl66" style="border-top: none; border-left: none;">Aug</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">136 230 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">1 266 666 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-1 266 666€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA</TD><TD class="xl66" style="border-top: none; border-left: none;">Sep</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">122 494 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">1 424 999 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-1 424 999€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA</TD><TD class="xl66" style="border-top: none; border-left: none;">Okt</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">151 407 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">1 583 332 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-1 583 332€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA</TD><TD class="xl66" style="border-top: none; border-left: none;">Nov</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">144 699 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">1 741 665 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-1 741 665€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA</TD><TD class="xl66" style="border-top: none; border-left: none;">Dec</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">190 661 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">1 900 000 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-1 900 000€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA</TD><TD class="xl67" style="border-top: none;">Total</TD><TD align="right" class="xl69">295 072 €</TD><TD align="right" class="xl69">1 742 615 €</TD><TD align="right" class="xl69">0 €</TD><TD align="right" class="xl69">0 €</TD><TD align="right" class="xl69">0 €</TD><TD align="right" class="xl69">0 €</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA+</TD><TD class="xl66" style="border-top: none; border-left: none;">Jan</TD><TD align="right" class="xl68">10 224 €</TD><TD align="right" class="xl68">1 728 €</TD><TD align="right" class="xl68">10 224 €</TD><TD align="right" class="xl68">21 667 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-11 443€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA+</TD><TD class="xl66" style="border-top: none; border-left: none;">Feb</TD><TD align="right" class="xl68">130 €</TD><TD align="right" class="xl68">43 694 €</TD><TD align="right" class="xl68">10 354 €</TD><TD align="right" class="xl68">43 333 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-32 979€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA+</TD><TD class="xl66" style="border-top: none; border-left: none;">Mar</TD><TD align="right" class="xl68">72 €</TD><TD align="right" class="xl68">55 574 €</TD><TD align="right" class="xl68">10 426 €</TD><TD align="right" class="xl68">65 000 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-54 573€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA+</TD><TD class="xl66" style="border-top: none; border-left: none;">Apr</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">37 447 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">86 666 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-86 666€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA+</TD><TD class="xl66" style="border-top: none; border-left: none;">Máj</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">4 265 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">108 333 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-108 333€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA+</TD><TD class="xl66" style="border-top: none; border-left: none;">Jún</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">27 482 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">130 000 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-130 000€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA+</TD><TD class="xl66" style="border-top: none; border-left: none;">Júl</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">9 618 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">151 666 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-151 666€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA+</TD><TD class="xl66" style="border-top: none; border-left: none;">Aug</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">13 637 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">173 333 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-173 333€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA+</TD><TD class="xl66" style="border-top: none; border-left: none;">Sep</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">6 680 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">194 999 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-194 999€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA+</TD><TD class="xl66" style="border-top: none; border-left: none;">Okt</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">22 964 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">216 666 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-216 666€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA+</TD><TD class="xl66" style="border-top: none; border-left: none;">Nov</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">8 566 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">238 333 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-238 333€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA+</TD><TD class="xl66" style="border-top: none; border-left: none;">Dec</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">24 169 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">260 000 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-260 000€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA+</TD><TD class="xl67" style="border-top: none;">Total</TD><TD align="right" class="xl69">10 426 €</TD><TD align="right" class="xl69">255 823 €</TD><TD align="right" class="xl69">0 €</TD><TD align="right" class="xl69">0 €</TD><TD align="right" class="xl69">0 €</TD><TD align="right" class="xl69">0 €</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">BBB</TD><TD class="xl66" style="border-top: none; border-left: none;">Jan</TD><TD align="right" class="xl68">14 760 €</TD><TD align="right" class="xl68">13 926 €</TD><TD align="right" class="xl68">14 760 €</TD><TD align="right" class="xl68">27 500 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-12 740€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">BBB</TD><TD class="xl66" style="border-top: none; border-left: none;">Feb</TD><TD align="right" class="xl68">23 272 €</TD><TD align="right" class="xl68">11 644 €</TD><TD align="right" class="xl68">38 031 €</TD><TD align="right" class="xl68">55 000 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-16 969€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">BBB</TD><TD class="xl66" style="border-top: none; border-left: none;">Mar</TD><TD align="right" class="xl68">133 €</TD><TD align="right" class="xl68">46 609 €</TD><TD align="right" class="xl68">38 164 €</TD><TD align="right" class="xl68">82 500 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-44 336€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">BBB</TD><TD class="xl66" style="border-top: none; border-left: none;">Apr</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">14 436 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">110 000 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-110 000€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">BBB</TD><TD class="xl66" style="border-top: none; border-left: none;">Máj</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">38 061 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">137 500 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-137 500€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">BBB</TD><TD class="xl66" style="border-top: none; border-left: none;">Jún</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">19 301 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">165 000 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-165 000€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">BBB</TD><TD class="xl66" style="border-top: none; border-left: none;">Júl</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">24 015 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">192 500 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-192 500€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">BBB</TD><TD class="xl66" style="border-top: none; border-left: none;">Aug</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">32 403 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">220 000 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-220 000€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">BBB</TD><TD class="xl66" style="border-top: none; border-left: none;">Sep</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">13 369 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">247 500 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-247 500€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">BBB</TD><TD class="xl66" style="border-top: none; border-left: none;">Okt</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">28 393 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">275 000 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-275 000€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">BBB</TD><TD class="xl66" style="border-top: none; border-left: none;">Nov</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">38 400 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">302 500 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-302 500€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">BBB</TD><TD class="xl66" style="border-top: none; border-left: none;">Dec</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">29 964 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">330 000 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-330 000€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">BBB</TD><TD class="xl67" style="border-top: none;">Total</TD><TD align="right" class="xl69">38 164 €</TD><TD align="right" class="xl69">310 521 €</TD><TD align="right" class="xl69">0 €</TD><TD align="right" class="xl69">0 €</TD><TD align="right" class="xl69">0 €</TD><TD align="right" class="xl69">0 €</TD></TR></TBODY></TABLE><P></P><P>I need to show only values to today´s mounth - so to march. Also I need to insert extra row between divisions - due to lucidity. The result table should be:</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 683px;"><TBODY><TR><TD class="xl65" height="17" width="64">Division</TD><TD class="xl66" style="border-left: none;" width="73">FinMounth</TD><TD class="xl67" width="103">Revenues 2017</TD><TD class="xl67" style="border-left: none;" width="103">Revenues 2016</TD><TD class="xl67" style="border-left: none;" width="112">Cumulative 2017</TD><TD class="xl67" style="border-left: none;" width="69">Plan 2017</TD><TD class="xl67" style="border-left: none;" width="64">after-admision</TD><TD class="xl67" style="border-left: none;" width="95">Change 16-17</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">AAA</TD><TD class="xl68" style="border-top: none; border-left: none;">Jan</TD><TD align="right" class="xl70">148 025 €</TD><TD align="right" class="xl70">112 067 €</TD><TD align="right" class="xl70">148 025 €</TD><TD align="right" class="xl70">158 333 €</TD><TD align="right" class="xl70">0 €</TD><TD align="right" class="xl70">-10 309€</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">AAA</TD><TD class="xl68" style="border-top: none; border-left: none;">Feb</TD><TD align="right" class="xl70">127 924 €</TD><TD align="right" class="xl70">163 539 €</TD><TD align="right" class="xl70">275 948 €</TD><TD align="right" class="xl70">316 666 €</TD><TD align="right" class="xl70">0 €</TD><TD align="right" class="xl70">-40 718€</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">AAA</TD><TD class="xl68" style="border-top: none; border-left: none;">Mar</TD><TD align="right" class="xl70">19 124 €</TD><TD align="right" class="xl70">177 144 €</TD><TD align="right" class="xl70">295 072 €</TD><TD align="right" class="xl70">475 000 €</TD><TD align="right" class="xl70">0 €</TD><TD align="right" class="xl70">-179 927€</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">AAA</TD><TD class="xl69" style="border-top: none;">Total</TD><TD align="right" class="xl71">295 072 €</TD><TD align="right" class="xl71">1 742 615 €</TD><TD align="right" class="xl71">0 €</TD><TD align="right" class="xl71">0 €</TD><TD align="right" class="xl71">0 €</TD><TD align="right" class="xl71">0 €</TD></TR><TR><TD colspan="1"></TD><TD colspan="1"></TD><TD colspan="1"></TD><TD colspan="1"></TD><TD colspan="1"></TD><TD colspan="1"></TD><TD colspan="1"></TD><TD colspan="1"></TD></TR><TR><TD class="xl68" height="17">AAA+</TD><TD class="xl68" style="border-left: none;">Jan</TD><TD align="right" class="xl70">10 224 €</TD><TD align="right" class="xl70">1 728 €</TD><TD align="right" class="xl70">10 224 €</TD><TD align="right" class="xl70">21 667 €</TD><TD align="right" class="xl70">0 €</TD><TD align="right" class="xl70">-11 443€</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">AAA+</TD><TD class="xl68" style="border-top: none; border-left: none;">Feb</TD><TD align="right" class="xl70">130 €</TD><TD align="right" class="xl70">43 694 €</TD><TD align="right" class="xl70">10 354 €</TD><TD align="right" class="xl70">43 333 €</TD><TD align="right" class="xl70">0 €</TD><TD align="right" class="xl70">-32 979€</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">AAA+</TD><TD class="xl68" style="border-top: none; border-left: none;">Mar</TD><TD align="right" class="xl70">72 €</TD><TD align="right" class="xl70">55 574 €</TD><TD align="right" class="xl70">10 426 €</TD><TD align="right" class="xl70">65 000 €</TD><TD align="right" class="xl70">0 €</TD><TD align="right" class="xl70">-54 573€</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">AAA+</TD><TD class="xl69" style="border-top: none;">Total</TD><TD align="right" class="xl71">10 426 €</TD><TD align="right" class="xl71">255 823 €</TD><TD align="right" class="xl71">0 €</TD><TD align="right" class="xl71">0 €</TD><TD align="right" class="xl71">0 €</TD><TD align="right" class="xl71">0 €</TD></TR><TR><TD colspan="1"></TD><TD colspan="1"></TD><TD colspan="1"></TD><TD colspan="1"></TD><TD colspan="1"></TD><TD colspan="1"></TD><TD colspan="1"></TD><TD colspan="1"></TD></TR><TR><TD class="xl68" height="17">BBB</TD><TD class="xl68" style="border-left: none;">Jan</TD><TD align="right" class="xl70">14 760 €</TD><TD align="right" class="xl70">13 926 €</TD><TD align="right" class="xl70">14 760 €</TD><TD align="right" class="xl70">27 500 €</TD><TD align="right" class="xl70">0 €</TD><TD align="right" class="xl70">-12 740€</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">BBB</TD><TD class="xl68" style="border-top: none; border-left: none;">Feb</TD><TD align="right" class="xl70">23 272 €</TD><TD align="right" class="xl70">11 644 €</TD><TD align="right" class="xl70">38 031 €</TD><TD align="right" class="xl70">55 000 €</TD><TD align="right" class="xl70">0 €</TD><TD align="right" class="xl70">-16 969€</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">BBB</TD><TD class="xl68" style="border-top: none; border-left: none;">Mar</TD><TD align="right" class="xl70">133 €</TD><TD align="right" class="xl70">46 609 €</TD><TD align="right" class="xl70">38 164 €</TD><TD align="right" class="xl70">82 500 €</TD><TD align="right" class="xl70">0 €</TD><TD align="right" class="xl70">-44 336€</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">BBB</TD><TD class="xl69" style="border-top: none;">Total</TD><TD align="right" class="xl71">38 164 €</TD><TD align="right" class="xl71">310 521 €</TD><TD align="right" class="xl71">0 €</TD><TD align="right" class="xl71">0 €</TD><TD align="right" class="xl71">0 €</TD><TD align="right" class="xl71">0 €</TD></TR></TBODY></TABLE><P></P><P>Thanks a lot for answer.</P></BODY></HTML> Tue, 14 Mar 2017 13:39:33 GMT jozisvk11 2017-03-14T13:39:33Z Pivot table https://community.qlik.com/t5/QlikView/Pivot-table/m-p/1287236#M402934 <HTML><HEAD></HEAD><BODY><P>I have the&nbsp; pivot table:</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 705px;"><TBODY><TR><TD class="xl63" height="17" width="54">Division</TD><TD class="xl64" style="border-left: none;" width="105">FinMounth</TD><TD class="xl65" width="103">Revenues 2017</TD><TD class="xl65" style="border-left: none;" width="103">Revenues 2016</TD><TD class="xl65" style="border-left: none;" width="112">Cumulative 2017</TD><TD class="xl65" style="border-left: none;" width="82">Plan 2017</TD><TD class="xl65" style="border-left: none;" width="51">after-admision</TD><TD class="xl65" style="border-left: none;" width="95">Change 16-17</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA</TD><TD class="xl66" style="border-top: none; border-left: none;">Jan</TD><TD align="right" class="xl68">148 025 €</TD><TD align="right" class="xl68">112 067 €</TD><TD align="right" class="xl68">148 025 €</TD><TD align="right" class="xl68">158 333 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-10 309€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA</TD><TD class="xl66" style="border-top: none; border-left: none;">Feb</TD><TD align="right" class="xl68">127 924 €</TD><TD align="right" class="xl68">163 539 €</TD><TD align="right" class="xl68">275 948 €</TD><TD align="right" class="xl68">316 666 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-40 718€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA</TD><TD class="xl66" style="border-top: none; border-left: none;">Mar</TD><TD align="right" class="xl68">19 124 €</TD><TD align="right" class="xl68">177 144 €</TD><TD align="right" class="xl68">295 072 €</TD><TD align="right" class="xl68">475 000 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-179 927€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA</TD><TD class="xl66" style="border-top: none; border-left: none;">Apr</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">152 992 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">633 333 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-633 333€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA</TD><TD class="xl66" style="border-top: none; border-left: none;">Máj</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">160 683 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">791 666 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-791 666€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA</TD><TD class="xl66" style="border-top: none; border-left: none;">Jún</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">122 923 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">949 999 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-949 999€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA</TD><TD class="xl66" style="border-top: none; border-left: none;">Júl</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">107 776 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">1 108 332 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-1 108 332€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA</TD><TD class="xl66" style="border-top: none; border-left: none;">Aug</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">136 230 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">1 266 666 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-1 266 666€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA</TD><TD class="xl66" style="border-top: none; border-left: none;">Sep</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">122 494 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">1 424 999 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-1 424 999€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA</TD><TD class="xl66" style="border-top: none; border-left: none;">Okt</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">151 407 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">1 583 332 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-1 583 332€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA</TD><TD class="xl66" style="border-top: none; border-left: none;">Nov</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">144 699 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">1 741 665 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-1 741 665€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA</TD><TD class="xl66" style="border-top: none; border-left: none;">Dec</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">190 661 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">1 900 000 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-1 900 000€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA</TD><TD class="xl67" style="border-top: none;">Total</TD><TD align="right" class="xl69">295 072 €</TD><TD align="right" class="xl69">1 742 615 €</TD><TD align="right" class="xl69">0 €</TD><TD align="right" class="xl69">0 €</TD><TD align="right" class="xl69">0 €</TD><TD align="right" class="xl69">0 €</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA+</TD><TD class="xl66" style="border-top: none; border-left: none;">Jan</TD><TD align="right" class="xl68">10 224 €</TD><TD align="right" class="xl68">1 728 €</TD><TD align="right" class="xl68">10 224 €</TD><TD align="right" class="xl68">21 667 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-11 443€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA+</TD><TD class="xl66" style="border-top: none; border-left: none;">Feb</TD><TD align="right" class="xl68">130 €</TD><TD align="right" class="xl68">43 694 €</TD><TD align="right" class="xl68">10 354 €</TD><TD align="right" class="xl68">43 333 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-32 979€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA+</TD><TD class="xl66" style="border-top: none; border-left: none;">Mar</TD><TD align="right" class="xl68">72 €</TD><TD align="right" class="xl68">55 574 €</TD><TD align="right" class="xl68">10 426 €</TD><TD align="right" class="xl68">65 000 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-54 573€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA+</TD><TD class="xl66" style="border-top: none; border-left: none;">Apr</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">37 447 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">86 666 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-86 666€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA+</TD><TD class="xl66" style="border-top: none; border-left: none;">Máj</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">4 265 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">108 333 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-108 333€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA+</TD><TD class="xl66" style="border-top: none; border-left: none;">Jún</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">27 482 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">130 000 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-130 000€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA+</TD><TD class="xl66" style="border-top: none; border-left: none;">Júl</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">9 618 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">151 666 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-151 666€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA+</TD><TD class="xl66" style="border-top: none; border-left: none;">Aug</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">13 637 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">173 333 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-173 333€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA+</TD><TD class="xl66" style="border-top: none; border-left: none;">Sep</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">6 680 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">194 999 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-194 999€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA+</TD><TD class="xl66" style="border-top: none; border-left: none;">Okt</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">22 964 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">216 666 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-216 666€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA+</TD><TD class="xl66" style="border-top: none; border-left: none;">Nov</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">8 566 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">238 333 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-238 333€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA+</TD><TD class="xl66" style="border-top: none; border-left: none;">Dec</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">24 169 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">260 000 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-260 000€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">AAA+</TD><TD class="xl67" style="border-top: none;">Total</TD><TD align="right" class="xl69">10 426 €</TD><TD align="right" class="xl69">255 823 €</TD><TD align="right" class="xl69">0 €</TD><TD align="right" class="xl69">0 €</TD><TD align="right" class="xl69">0 €</TD><TD align="right" class="xl69">0 €</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">BBB</TD><TD class="xl66" style="border-top: none; border-left: none;">Jan</TD><TD align="right" class="xl68">14 760 €</TD><TD align="right" class="xl68">13 926 €</TD><TD align="right" class="xl68">14 760 €</TD><TD align="right" class="xl68">27 500 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-12 740€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">BBB</TD><TD class="xl66" style="border-top: none; border-left: none;">Feb</TD><TD align="right" class="xl68">23 272 €</TD><TD align="right" class="xl68">11 644 €</TD><TD align="right" class="xl68">38 031 €</TD><TD align="right" class="xl68">55 000 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-16 969€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">BBB</TD><TD class="xl66" style="border-top: none; border-left: none;">Mar</TD><TD align="right" class="xl68">133 €</TD><TD align="right" class="xl68">46 609 €</TD><TD align="right" class="xl68">38 164 €</TD><TD align="right" class="xl68">82 500 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-44 336€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">BBB</TD><TD class="xl66" style="border-top: none; border-left: none;">Apr</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">14 436 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">110 000 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-110 000€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">BBB</TD><TD class="xl66" style="border-top: none; border-left: none;">Máj</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">38 061 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">137 500 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-137 500€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">BBB</TD><TD class="xl66" style="border-top: none; border-left: none;">Jún</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">19 301 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">165 000 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-165 000€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">BBB</TD><TD class="xl66" style="border-top: none; border-left: none;">Júl</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">24 015 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">192 500 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-192 500€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">BBB</TD><TD class="xl66" style="border-top: none; border-left: none;">Aug</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">32 403 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">220 000 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-220 000€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">BBB</TD><TD class="xl66" style="border-top: none; border-left: none;">Sep</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">13 369 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">247 500 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-247 500€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">BBB</TD><TD class="xl66" style="border-top: none; border-left: none;">Okt</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">28 393 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">275 000 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-275 000€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">BBB</TD><TD class="xl66" style="border-top: none; border-left: none;">Nov</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">38 400 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">302 500 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-302 500€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">BBB</TD><TD class="xl66" style="border-top: none; border-left: none;">Dec</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">29 964 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">330 000 €</TD><TD align="right" class="xl68">0 €</TD><TD align="right" class="xl68">-330 000€</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">BBB</TD><TD class="xl67" style="border-top: none;">Total</TD><TD align="right" class="xl69">38 164 €</TD><TD align="right" class="xl69">310 521 €</TD><TD align="right" class="xl69">0 €</TD><TD align="right" class="xl69">0 €</TD><TD align="right" class="xl69">0 €</TD><TD align="right" class="xl69">0 €</TD></TR></TBODY></TABLE><P></P><P>I need to show only values to today´s mounth - so to march. Also I need to insert extra row between divisions - due to lucidity. The result table should be:</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 683px;"><TBODY><TR><TD class="xl65" height="17" width="64">Division</TD><TD class="xl66" style="border-left: none;" width="73">FinMounth</TD><TD class="xl67" width="103">Revenues 2017</TD><TD class="xl67" style="border-left: none;" width="103">Revenues 2016</TD><TD class="xl67" style="border-left: none;" width="112">Cumulative 2017</TD><TD class="xl67" style="border-left: none;" width="69">Plan 2017</TD><TD class="xl67" style="border-left: none;" width="64">after-admision</TD><TD class="xl67" style="border-left: none;" width="95">Change 16-17</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">AAA</TD><TD class="xl68" style="border-top: none; border-left: none;">Jan</TD><TD align="right" class="xl70">148 025 €</TD><TD align="right" class="xl70">112 067 €</TD><TD align="right" class="xl70">148 025 €</TD><TD align="right" class="xl70">158 333 €</TD><TD align="right" class="xl70">0 €</TD><TD align="right" class="xl70">-10 309€</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">AAA</TD><TD class="xl68" style="border-top: none; border-left: none;">Feb</TD><TD align="right" class="xl70">127 924 €</TD><TD align="right" class="xl70">163 539 €</TD><TD align="right" class="xl70">275 948 €</TD><TD align="right" class="xl70">316 666 €</TD><TD align="right" class="xl70">0 €</TD><TD align="right" class="xl70">-40 718€</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">AAA</TD><TD class="xl68" style="border-top: none; border-left: none;">Mar</TD><TD align="right" class="xl70">19 124 €</TD><TD align="right" class="xl70">177 144 €</TD><TD align="right" class="xl70">295 072 €</TD><TD align="right" class="xl70">475 000 €</TD><TD align="right" class="xl70">0 €</TD><TD align="right" class="xl70">-179 927€</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">AAA</TD><TD class="xl69" style="border-top: none;">Total</TD><TD align="right" class="xl71">295 072 €</TD><TD align="right" class="xl71">1 742 615 €</TD><TD align="right" class="xl71">0 €</TD><TD align="right" class="xl71">0 €</TD><TD align="right" class="xl71">0 €</TD><TD align="right" class="xl71">0 €</TD></TR><TR><TD colspan="1"></TD><TD colspan="1"></TD><TD colspan="1"></TD><TD colspan="1"></TD><TD colspan="1"></TD><TD colspan="1"></TD><TD colspan="1"></TD><TD colspan="1"></TD></TR><TR><TD class="xl68" height="17">AAA+</TD><TD class="xl68" style="border-left: none;">Jan</TD><TD align="right" class="xl70">10 224 €</TD><TD align="right" class="xl70">1 728 €</TD><TD align="right" class="xl70">10 224 €</TD><TD align="right" class="xl70">21 667 €</TD><TD align="right" class="xl70">0 €</TD><TD align="right" class="xl70">-11 443€</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">AAA+</TD><TD class="xl68" style="border-top: none; border-left: none;">Feb</TD><TD align="right" class="xl70">130 €</TD><TD align="right" class="xl70">43 694 €</TD><TD align="right" class="xl70">10 354 €</TD><TD align="right" class="xl70">43 333 €</TD><TD align="right" class="xl70">0 €</TD><TD align="right" class="xl70">-32 979€</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">AAA+</TD><TD class="xl68" style="border-top: none; border-left: none;">Mar</TD><TD align="right" class="xl70">72 €</TD><TD align="right" class="xl70">55 574 €</TD><TD align="right" class="xl70">10 426 €</TD><TD align="right" class="xl70">65 000 €</TD><TD align="right" class="xl70">0 €</TD><TD align="right" class="xl70">-54 573€</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">AAA+</TD><TD class="xl69" style="border-top: none;">Total</TD><TD align="right" class="xl71">10 426 €</TD><TD align="right" class="xl71">255 823 €</TD><TD align="right" class="xl71">0 €</TD><TD align="right" class="xl71">0 €</TD><TD align="right" class="xl71">0 €</TD><TD align="right" class="xl71">0 €</TD></TR><TR><TD colspan="1"></TD><TD colspan="1"></TD><TD colspan="1"></TD><TD colspan="1"></TD><TD colspan="1"></TD><TD colspan="1"></TD><TD colspan="1"></TD><TD colspan="1"></TD></TR><TR><TD class="xl68" height="17">BBB</TD><TD class="xl68" style="border-left: none;">Jan</TD><TD align="right" class="xl70">14 760 €</TD><TD align="right" class="xl70">13 926 €</TD><TD align="right" class="xl70">14 760 €</TD><TD align="right" class="xl70">27 500 €</TD><TD align="right" class="xl70">0 €</TD><TD align="right" class="xl70">-12 740€</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">BBB</TD><TD class="xl68" style="border-top: none; border-left: none;">Feb</TD><TD align="right" class="xl70">23 272 €</TD><TD align="right" class="xl70">11 644 €</TD><TD align="right" class="xl70">38 031 €</TD><TD align="right" class="xl70">55 000 €</TD><TD align="right" class="xl70">0 €</TD><TD align="right" class="xl70">-16 969€</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">BBB</TD><TD class="xl68" style="border-top: none; border-left: none;">Mar</TD><TD align="right" class="xl70">133 €</TD><TD align="right" class="xl70">46 609 €</TD><TD align="right" class="xl70">38 164 €</TD><TD align="right" class="xl70">82 500 €</TD><TD align="right" class="xl70">0 €</TD><TD align="right" class="xl70">-44 336€</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">BBB</TD><TD class="xl69" style="border-top: none;">Total</TD><TD align="right" class="xl71">38 164 €</TD><TD align="right" class="xl71">310 521 €</TD><TD align="right" class="xl71">0 €</TD><TD align="right" class="xl71">0 €</TD><TD align="right" class="xl71">0 €</TD><TD align="right" class="xl71">0 €</TD></TR></TBODY></TABLE><P></P><P>Thanks a lot for answer.</P></BODY></HTML> Tue, 14 Mar 2017 13:39:33 GMT https://community.qlik.com/t5/QlikView/Pivot-table/m-p/1287236#M402934 jozisvk11 2017-03-14T13:39:33Z Re: Pivot table https://community.qlik.com/t5/QlikView/Pivot-table/m-p/1287237#M402935 <HTML><HEAD></HEAD><BODY><P>in the dimension </P><P></P><P>if(<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">FinMounth</SPAN>=month(today()),<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">FinMounth</SPAN>)</P><P></P><P>then check the suppress null in the dimension tab ...</P></BODY></HTML> Tue, 14 Mar 2017 13:42:31 GMT https://community.qlik.com/t5/QlikView/Pivot-table/m-p/1287237#M402935 avinashelite 2017-03-14T13:42:31Z Re: Pivot table https://community.qlik.com/t5/QlikView/Pivot-table/m-p/1287238#M402936 <HTML><HEAD></HEAD><BODY><P>it si OK, thank you <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 14 Mar 2017 13:47:02 GMT https://community.qlik.com/t5/QlikView/Pivot-table/m-p/1287238#M402936 jozisvk11 2017-03-14T13:47:02Z Re: Pivot table https://community.qlik.com/t5/QlikView/Pivot-table/m-p/1287239#M402937 <HTML><HEAD></HEAD><BODY><P>and extra free<SPAN style="font-size: 10pt; line-height: 1.5em;">row between divison ? don´t you know ?</SPAN></P></BODY></HTML> Tue, 14 Mar 2017 13:52:07 GMT https://community.qlik.com/t5/QlikView/Pivot-table/m-p/1287239#M402937 jozisvk11 2017-03-14T13:52:07Z Re: Pivot table https://community.qlik.com/t5/QlikView/Pivot-table/m-p/1287240#M402938 <HTML><HEAD></HEAD><BODY><P>We don't have a direct way to achieve that , check this </P><P><A href="https://community.qlik.com/thread/40936">Insert Blank Lines in Pivot Table</A></P><P><A href="https://community.qlik.com/thread/136996">Blank values in Pivot table</A></P></BODY></HTML> Tue, 14 Mar 2017 15:07:10 GMT https://community.qlik.com/t5/QlikView/Pivot-table/m-p/1287240#M402938 avinashelite 2017-03-14T15:07:10Z