Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
warrentk80
Creator
Creator

Dynamic Aggres

Goodmorning everyone

I would need to count the months consumed by the resources of a company.

however, the database has for each resource the same month repeated because there are other fields (activity type, amounts etc ...)

count (TOTAL <[Consuntivi.Resource Full Name]> DISTINCT ([Consuntivi.Time Sheet Period]))

the formula works at the single resource level, but the table is dynamic and I can select the dimensions.

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.

I'll explain better with an example, attached excel file with the correct resource data
if I remove the first field (resource) how do I do on the field for the final months to get 322 and not 8?

thank you all for your cooperation

Andrew

0 Replies