topic Dynamic Aggres in QlikView https://community.qlik.com/t5/QlikView/Dynamic-Aggres/m-p/136229#M509058 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">Goodmorning everyone<BR /><BR />I would need to count the months consumed by the resources of a company.<BR /><BR /><SPAN>however, the database has for each resource the same month repeated because there are other fields (activity type, amounts etc ...)</SPAN><BR /><BR />count (TOTAL &lt;[Consuntivi.Resource Full Name]&gt; DISTINCT ([Consuntivi.Time Sheet Period]))<BR /><BR /><SPAN>the formula works at the single resource level, but the table is dynamic and I can select the dimensions.</SPAN><BR /><BR /><SPAN>if I select the resource all right, but if I deselect it and choose the resource manager, the result is the distinct months for that menager and not the sum of the months of all the resources.</SPAN><BR /><BR /><SPAN>I'll explain better with an example, attached excel file with the correct resource data</SPAN><BR /><SPAN>if I remove the first field (resource) how do I do on the field for the final months to get 322 and not 8?</SPAN><BR /><BR /><SPAN>thank you all for your cooperation</SPAN><BR /><BR />Andrew</SPAN></P></BODY></HTML> Tue, 18 Sep 2018 08:04:55 GMT warrentk80 2018-09-18T08:04:55Z Dynamic Aggres https://community.qlik.com/t5/QlikView/Dynamic-Aggres/m-p/136229#M509058 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">Goodmorning everyone<BR /><BR />I would need to count the months consumed by the resources of a company.<BR /><BR /><SPAN>however, the database has for each resource the same month repeated because there are other fields (activity type, amounts etc ...)</SPAN><BR /><BR />count (TOTAL &lt;[Consuntivi.Resource Full Name]&gt; DISTINCT ([Consuntivi.Time Sheet Period]))<BR /><BR /><SPAN>the formula works at the single resource level, but the table is dynamic and I can select the dimensions.</SPAN><BR /><BR /><SPAN>if I select the resource all right, but if I deselect it and choose the resource manager, the result is the distinct months for that menager and not the sum of the months of all the resources.</SPAN><BR /><BR /><SPAN>I'll explain better with an example, attached excel file with the correct resource data</SPAN><BR /><SPAN>if I remove the first field (resource) how do I do on the field for the final months to get 322 and not 8?</SPAN><BR /><BR /><SPAN>thank you all for your cooperation</SPAN><BR /><BR />Andrew</SPAN></P></BODY></HTML> Tue, 18 Sep 2018 08:04:55 GMT https://community.qlik.com/t5/QlikView/Dynamic-Aggres/m-p/136229#M509058 warrentk80 2018-09-18T08:04:55Z