I have searched for similar topics but none of the solutions exactly match my needs, so I need some help on calculating percentage with conditions and grouping, plus the average percentage for the entire company. A simple sample data table looks like this:
So I would need to calculate the percetage of chargeable values per team over a period of time (say month), with the possibility to further drill down by industry, by Active type (y/n), also the entire company average (not just per team) per industry and other parameters.
I would need average per quarter/year, and moving average too. But I know how to do this with a proper time/calendar table. So getting the actual conditional percentage calculated correctly is the main problem. Any help and suggestion is appreciated. Thanks.
Solved! Go to Solution.