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
