topic Re: Pivot Table (dynamic row restriction) in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-dynamic-row-restriction/m-p/451880#M563360 <HTML><HEAD></HEAD><BODY><P>See attached qvw</P></BODY></HTML> Tue, 19 Feb 2013 18:54:56 GMT Gysbert_Wassenaar 2013-02-19T18:54:56Z Pivot Table (dynamic row restriction) https://community.qlik.com/t5/QlikView/Pivot-Table-dynamic-row-restriction/m-p/451879#M563359 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a kind of advanced question. Is it possible to create a pivot table that hide row values depening on the number of dimension values? This combined with that the totals still should be summed up for all dimensions.</P><P></P><P>I attach a principle example. I dont want to restrict my dimensions since then i dont get the full total. Any ideas?</P><P></P><P></P><P>I want get from this</P><P><IMG __jive_id="33689" class="jive-image-thumbnail jive-image" onclick="" alt="Untitled.png" src="https://community.qlik.com/legacyfs/online/33689_Untitled.png" width="450" /></P><P>to this: </P><P></P><P><IMG __jive_id="33690" class="jive-image-thumbnail jive-image jiveImage" onclick="" alt="Goal.png" src="https://community.qlik.com/legacyfs/online/33690_Goal.png" width="450" /></P><P></P><P></P><P>any ideas are welcome, </P><P>br</P><P>Paul</P></BODY></HTML> Tue, 19 Feb 2013 18:26:42 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-dynamic-row-restriction/m-p/451879#M563359 pauljohansson 2013-02-19T18:26:42Z Re: Pivot Table (dynamic row restriction) https://community.qlik.com/t5/QlikView/Pivot-Table-dynamic-row-restriction/m-p/451880#M563360 <HTML><HEAD></HEAD><BODY><P>See attached qvw</P></BODY></HTML> Tue, 19 Feb 2013 18:54:56 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-dynamic-row-restriction/m-p/451880#M563360 Gysbert_Wassenaar 2013-02-19T18:54:56Z Re: Pivot Table (dynamic row restriction) https://community.qlik.com/t5/QlikView/Pivot-Table-dynamic-row-restriction/m-p/451881#M563361 <HTML><HEAD></HEAD><BODY><P>Thanks for fast reply</P><P></P><P>br</P><P>/Paul</P></BODY></HTML> Tue, 19 Feb 2013 19:03:55 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-dynamic-row-restriction/m-p/451881#M563361 pauljohansson 2013-02-19T19:03:55Z